AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIN4108GKimberk Frederick S · Cambridge, MAN4108JMetoyer Eric D · Yukon, OKN4108QStuckle Gary W · Davenport, WAN4108SBto Aviation LLC · Eden Prairie, MNN4108ZRamstad Trygg J · Anchorage, AKN4109BMccowan Joseph F · Sylvania, OHN4109NRoss George H · Delano, MNN4109ZAlf Robert R · Elkhorn, NEN410ABBloxsom Allan P III · Boerne, TXN410ADCon Air LLC · Okeana, OHN410AFJm Aviation II LLC · Little Falls, MNN410BLRegistered aircraftN410BPWeiss Michael K · Paige, TXN410BSCorestrength LLC · San Francisco, CAN410BWHeffelfinger Darin W · Sterling, ILN410CEBurggraf Sean Hj · Grand Rapids, MNN410CRAtp Aircraft 8 LLC · Wilmington, DEN410CVCivil Air Patrol · Maxwell Afb, ALN410DPConner Mark A · Palmetto, FLN410DRJmsat Corp · Moneta, VAN410DVVangrunsven Richard E · Hillsboro, ORN410EKGandy Donald T · Weatherford, TXN410EMMatejka Jeffrey M · Maple, NCN410ETAndervick · Dalton, GAN410FBLuna Roan C · Walled Lake, MIN410FPN19630 LLC · Fort Collins, CON410FRRegistration Pending · Pottstown, PARegistration pendingN410FSMaloney Daniel D · East Amherst, NYN410HAWalega Jane Ellen · Essex, MDN410JRoberts Klint E · Granbury, TXN410JAOrrick Donald M · Pleasant Prairie, WIN410JBTremble Jason · Granbury, TXN410JCFbn Holding Corp · Larkspur, CAN410JJHoskins Joseph L · Graham, WAN410KCTerrapin Station Air LLC · Spokane, WAN410LNormandeau Daniel R · Thompson Falls, MTN410LJBednar David · Norwalk, IAN410LRWings Over Texas Holdings LLC · Denton, TXN410MJSnuggs Jason M · Gainesville, TXN410MTAcron Aviation Academy Inc · Sanford, FLN410MVWester William Douglas · Chewelah, WAN410MWSandeford Ralph H · Midville, GAN410NFMurphy Aviation Inc · Gilroy, CAN410PBUhlik Chris R · Vancouver, WAN410PCBohnert Matthew · Bend, ORN410PGPessina Guy · Palmetto, FLN410PJVolk Timothy · Springfield, OHN410PKEnergy And Environment LLC · Fayette, MEN410PUObrien Terence · Bonney Lake, WA
Back to AD 2007-04-19 R1