AD 2002-07-01
Registered aircraft · 3,466
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7389UYr-Aircraft Leasing LLC · Bethel, AKN7391PShph LLC · Edwards, ILN7392USpernak Airways Inc · Anchorage, AKFirst renewal noticeN7396UAlaska Aircraft Leasing LLC · Silverdale, WAN739MCaurus Power Inc · Santa Rosa, CAN73CYRti Fabrication Inc · Plains, MTN73LLT3 Aviation LLC · Oak Point, TXN73RBTurbo Centurion LLC · North Salt Lake, UTN740United States Department Of Interior · Boise, IDN7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKN74206Chinn Larry · Anatone, WAN7433NFixed Gear LLC · Sherwood, ARN7448NCcx-2000-0111 LLC · Garberville, CAN744RCastaneda Jose · Yakima, WAN745KPPaklook Air Inc Dbi · Bethel, AKFirst renewal noticeN746KPFox Aircraft LLC · Wasilla, AKN746ZXSlater R Winston Trustee · St Charles, ILN7476QSmith Keith S · Fredericksburg, TXN747SQYr-Aircraft Leasing LLC · Bethel, AKN7485QEvans Charles H Trustee · Hooksett, NHN7487Q206 LLC · Anchorage, AKN748KPKalinin Partners LLC · Juneau, AKN749KPKalinin Partners LLC · Juneau, AKN749RVTime Machine LLC · Kailua Kona, HIN749SPNew York State Police · Latham, NYN74ESValiair Ltd Co Trustee · Casper, WYN74LCLee County Sheriffs Office · Ft Myers, FLN74MMFief Ron C · Creede, CON74PSOrion Works Inc · Denali Park, AKN74RMGrimes Taylor · Odessa, TXN750NTEle Motorsports LLC · Dover, DEN7532NEagle Air LLC · Morgantown, WVN7539NDavis Dale L · Boerne, TXN7551ZKustatan Leasing LLC · Kenai, AKN7559KSkyway II LLC · Naples, FLN755CMCluster Fish LLC · Charleston, SCN755SWMelendez Daniel Alexan · Yuma, AZN7561NPierce County Sheriffs Department · South Hill, WAN7567KCutler Jeffrey R · Columbus, INN7567QJolley Joseph J · Anchorage, AKN7568270 North LLC · Anchorage, AKN7568MPeters William R · Naperville, ILN7569NArctic Aviation Leasing LLC · Anchorage, AKN756AHKincaid Linda C · North Pole, AKN756ANJelinek Tyson · Iola, KSN756AVSmith Air LLC · Cascade, IDN756BBCampbell Steven P · Annapolis, CAN756BNBeck Skydiving & Rigging LLC · Bixby, OKN756BYW Yerxa LLC · Colusa, CAN756CLEgli Sam · King Salmon, AK
Back to AD 2002-07-01