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.
N68RLSlutz David E · Morristown, TNN68RRBaker Nelson J · Ocean City, NJN68RSAlston Walter III · Fernandina Beach, FLN68RVSteed David A · Oklahoma City, OKN68SBLucey William E · Salisbury, NCN68SCBridges Lee P · Smithville, TNN68SVAviat Aircraft Inc · Afton, WYN68TLShoenberger James · Orlando, FLN68VCammack Daniel P · Colorado Springs, CON68VAAspen Helicopters Inc · Oxnard, CAN68VRGene Coleman Machine Inc · Menominee, MIN68VVWhite Mark E · Charleston, WVN68WLGlobal Pilot Inc · Wilmington, DEN68WPButseev Anthony · Tarzana, CAN68WYAviation Mentoring Program LLC · Phoenix, AZN68XLsk Aviation Corp · Wilmington, DEN6900Adams Paul T · Pompano Beach, FLN69007Jj Kramer Aviation LLC · Vero Beach, FLN69009Jwa Flight School LLC · Bolingbrook, ILN6900DMahoney Shane · Auburn, WAN6900HCp Aviation Inc · Santa Paula, CAN6900JCaruso Jerry W Jr · Kingsbury, NYN6900NBond William E · Elk River, MNN6900PMyer Charles G · Forest Lake, MNN6900URegistered aircraftN6900WHall William Brent · Tulia, TXN69011Sunrise Aviation Inc · Ormond Beach, FLN69012Chapel Hill Flying Club Incdba · Sanford, NCN69016Hillsboro Aero Academy LLC · Hillsboro, ORN69019Lange Walter · Plymouth, MAN6901ASpence Stephen L · Anchorage, AKN6901HRieser Steven E II · Baltimore, OHN6901NRagsdale James W · Geneva, FLN6901QCbus Flight LLC · Pickerington, OHN6901ULime Lounge LLC · Des Moines, IAN69023Gilbert Jeffrey R · Dahlonega, GAN6902DFerrell Alan B · Arlington, OHN6902NSherrill Charles H · Robert Lee, TXN69031Lewis Garry L · Livingston, LAN69036Long Robert D · Kinston, NCN6903BJones Gary L · Kerrville, TXN6903JGreen Valley Aerospace LLC · Lexington, VAN6903NRoland Jason R · Royse City, TXN6903QSullivan Lynford M · Hernando, MSN6903UPray Aviation Inc · Augusta, KSN69042Poplar Grove Airmotive Inc · Poplar Grove, ILN69043Davidson Craig H · Heber City, UTN69045Eburg Aero LLC · Ellensburg, WAN69047Wings Over Texas Holdings LLC · Denton, TXN6904DLucas Michael F · Germantown, OH
Back to AD 90-04-06 R1