AD 2012-03-07
Registered aircraft · 62,071
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:2012-03-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-07')
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:2012-03-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-07') 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.
N106RBSpeck Gregory J · Oak Harbor, WAN106RDMarinaphoto Helicopter LLC · Rehoboth Beach, DEN106RMArmstrong Ronald W · Brownsville, TXN106RTSobota Thomas J · Canton, MIN106SMMorris Geoffrey J · Henderson, NVN106TUDesmit Matthew L · Centerton, ARN106UCInsuraclaim LLC · Boca Raton, FLN106WRegistered aircraftN106WPAero Research LLC · Avondale Estates, GAFirst renewal noticeN106WTSchafer Timothy · Soldotna, AKN1071CBmk Aviation LLC · Northampton, PAN1071PFlying Circus Aircraft LLC · Manitou Beach, MIN1071XPeter Prince Aviation Center LLC · Milton, FLN1072AScarboro Thomas E · North Pole, AKN1072ESabbatino Robert F · New Milford, CTN1072QCoastal Air Inc · Groton, CTN1072XDemaagd Ross E · Middleville, MIN10734Phelps Jay R · Somerville, ALN1073APeters Steven M · Parkersburg, WVN1073BPickering Michael A · Walpole, NHN1073EMurphys Flying Service LLC · Thomasville, GAN1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLN1074TIowa Lakes Community College · Estherville, IAN1075ABates Hobart C · Dexter, MIN1075EWeiland Adam W · Evergreen, CON1075RGeorgia Aviation Authority · Eastman, GAN1076Weaver Yvon · Carson City, NVN1076ATri City Airframe LLC · Kalispell, MTN1076QExecutive Flight Institute LLC · Murrieta, CAN1076XMarston Lester J · Ukiah, CAN1077CMckinney Jonathan C · Oviedo, FLN1078AHall Alan R · Enumclaw, WAN1078MGeorge Gary D · Humble, TXN10792Wingnut Inc · Wilmington, DEN10799Brown Eric · Morganton, GAN1079MGeneral Aviation LLC · Henderson, NVN1079YBoyer Jerry D · Monument, ORN107AKLazzaro Chris C · Solvang, CAN107AMYoung Mark · Vancouver, WAN107BAFairmont State University · Fairmont, WVN107CGColon Orlando · San Juan, PRN107DSweeney Edward C Jr · Parrish, FLN107DMCleveland Allan B · Independence, ORN107ESWalpole John W · Iola, TXN107FRjm Aviation Partners Inc · Naples, FLN107FHThree Sixteen LLC · Danbury, TXN107GASwink James E · Flint, TXN107JMCyphers Sam K · Sequim, WAN107MECash LLC · Kersey, CON107MRMeriden Aviation Center LLC · Meriden, CT
Back to AD 2012-03-07