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.
N28848Voltz John H · Alexandria, LAN2884ADowns M Todd · De Leon, TXFirst renewal noticeN2884DThree Wing Flight School LLC · Stratford, CTN2884FTurner Michael B · Covington, TNN2884KJ Robert Finley And Associates Inc · Mountain Home, ARN2884MWattum Investments LLC · Kodiak, AKN2884PRocky Creek Jbd Inc · Boca Grande, FLN2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeN2884TBonner John A · Riverside, CAN2884XAngle Of Attack Flying Company LLC · Springfield, MON2884YTri-Aviation Inc · Amarillo, TXN28852Cae Aviation Academy Phoenix LLC · Mesa, AZN28854Air Devices Co LLC · Alpena, MIN28856Thompson Mitchell L · Exton, PAN28857Sentell Charles S III · Minden, LAN28859Newman Richard Donald · Mercer Island, WAN2885DLehigh Valley Flying Club Inc · Lehigh Valley, PAN2885FDunkly Daniel L · Chico, CAN2885GWisconsin Aviation Inc · Watertown, WIN2885KDierkes Steven P · Henderson, NVN2885PLeprechaun Air Service Inc · Syracuse, KSN2885QFisher Global LLC · Conway, ARN2885RArrow Flight LLC · Springfield, VAN2885YMiner Bradford Aviation LLC · Spanish Fork, UTN2885ZMclaughlin Paul E · Mansfield, OHN28863Koleszar John R · Lynnfield, MAN28865Maritime Aviation LLC · Kalispell, MTN28866Marcoski Edward T · Downers Grove, ILN28869Registered aircraftN2886FWeldon Larry W · Titusville, PAN2886KTallman George L Jr · Ocala, FLN2886PBurg Mark S · Powell Butte, ORN2886QWright Flyers Club Inc · Huber Heights, OHN2886TAtkins Joseph Van · Lenoir, NCN2886WBushong Chistopher L · Gulf Shores, ALN2886ZNettles William C · Soldotna, AKN28878Alsup Patrick J · League City, TXN28879Cady Eugene Roland · Port Orange, FLN2887EMeeker Stanton · Squaw Valley, CAN2887PGoldberg Aviation · Cody, WYN2887RNaylor Michael Scott · Modesto, CAN2887TSanetra George W · Gary, INN2887XTolmachev Nikolay A · Anchorage, AKN2887ZElliott Robert M · Sweetwater, TXN28881Buttery Craig B · Loxahatchee, FLN28887Danos Laura S · Hampton Falls, NHN2888ESterett Terry Alan Jr · New Port Richey, FLN2888FLynch Neil E · Ceresco, MIN2888GClark Larry K · Sedalia, CON2888KBooth William R Jr · Sterling, AK
Back to AD 2007-04-19 R1