AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N4870GCal Aggie Flying Farmers Inc · Davis, CAN4870LWinyah Aviation LLC · Georgetown, SCN4870PWooten Gerry W · Edmond, OKN4870UUniversity Of Oklahoma · Norman, OKN48710Conner Michael James · Scotts Valley, CAN4871BMeise Fred Walter · Moses Lake, WAN4871CFalvey Paul J · Edgartown, MAN4871ESloss John W · Sterling, AKN4871VBt Aero Precission Flight Accademy LLC · Oakdale, CAN48725Wings Over Texas Holdings LLC · Denton, TXN4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeN4872DPs N4872d LLC · Green Bay, WIN4872LMartin Marvin J · Conrath, WIN4873APapp Jacob R · Fort Edward, NYN4873FFirebrand Nation · Knoxville, TNN4873G4873g Flying Club Inc · Punxsutawney, PAN4873LBaker Justin · Titusville, FLN4874Goin Jeff Trustee · Polk City, FLN4874BKoppelmann Kevin J · Cuba, MON4874TSmith Richard R Sr · Wellington, NVN48751Tyau Jon S · Las Vegas, NVN48753Harford Flying Club Inc · Kingsville, MDN48757Stone To Glass LLC · Lake Worth, FLN4875DNightwing Productions LLC · Aptos, CAN4875FVan Kirk Ronald · Wichita Falls, TXN4875ZRice Gary W · San Antonio, TXN48762Carter Flygare Inc · Sacramento, CAN48763Jet & Rotor Aviation LLC · Sacramento, CAN48764Cohen Harold L · Pensacola, FLN48768General Aviation Support Corp · Rosamond, CAN4876AMontgomery Daniel G · Wasilla, AKN4876EFarrell Clifton S · Needville, TXN4876FCosta Air Service LLC · Painted Post, NYN4876GKing Bryan A · Austin, TXN4876TAyers Terry · Boise, IDN48779Bryan Robert G · Orland Park, ILN4877DAviator Air Flight School LLC · Grand Prairie, TXN4877JR&R Aero Services LLC · Eden Prairie, MNN4877LTxp Designs LLC · Jasper, INN4878Medic Choppers LLC · Springdale, ARN48787Angel Aviation Inc · Peoria, AZN4878AMallek Edward J · Fairbanks, AKN4878BSun Aircraft Management LLC · Ormond Beach, FLN4878LPeg Aviation LLC · Cedar Hill, TNN4878TLorbiecki John E · Hubertus, WIN4879DMorey Airplane Company Inc · Middleton, WIN4879EPappas William B · Dallas, TXN4879TCombs Kenneth E · Canyon, TXN4879ZRobert P Brown Inc · Beatty, ORN487AArcher Aircraft LLC · Wilmington, DE
Back to AD 90-04-06 R1