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.
N8189SAirplanes Unlimited LLC · Jackson, TNN8189WTri-City Mens Health LLC · Prescott, AZN818BBLangenhahn Jesse · Aliquippa, PAN818BGMetz Joshua J · Peever, SDN818DCCarr Donald A · Saratoga, CAN818DVQuiroz Rene Joseph · Matthews, NCN818GRAngel Aviation LLC · Paradise, KSN818GSRegistered aircraftN818HEMaxwell James P · Rolling Prairie, INN818KDSunburst Aviation LLC · Fountain Hills, AZN818RButler John · Hazelhurst, WIN818RDDomenico Ricky A · Westminster, CON818RVRegistered aircraftN818SPN818xp LLC · Charleston, SCN818TSlipstream Aviation LLC · Carrollton, GAN818TAFoothill Aviation LLC · Iliamna, AKN818TRBadger Land Aero LLC · Las Vegas, NVN818VCMann John Franklin Jr · Manetta, GAN818VHAltitude Aviatin Services LLC · Mountain Home, IDN818VMReitz Brian C · Tehachapi, CAN818WCCrawford Beau W · Willow, AKN818WDWhiskey Bravo II LLC · Newton, KSN818WTPlane Fun Inc Tr Trustee · Snellville, GAN818WWMorrison Douglas K · North Branch, NJN818YInternational Air Services Inc Trustee · Carson City, NVN819Huseby Kelly E · Hulett, WYN8190CBent James L Jr DBA · Palatine Bridge, NYN8190DMagnuson Lucile · Mc Grath, AKN8190WA&M Aviation LLC · Tewksbury, MAN81916Rrg Software LLC · Alpine, CAN8191CLee Gerald R · Glennallen, AKN8191DSwede Aviation LLC · Tucson, AZN8191VNelson Ronald R · Berthoud, CON8191XA&J Aircraft Leasing Inc · Burlington, CON81926Burkhardt David · Oregon City, ORN8192CD&K Aviation Inc · Milford, IAN8192DGlasheen Sean T · Bethel, AKN8192NNaber Adam T · Fort Atkinson, WIN8192PAhmadi Michael · Attleboro, MAN8192WHenley Edward F · Headland, ALN8192YPlane Fun Inc Tr Trustee · Snellville, GAN8193WButler Austen James · Charlotte, NCN8194CWilliams Mark S · Lisbon, OHN8194DPalin Todd M · Wasilla, AKN8194JTipton Aero Shares LLC · Fort Meade, MDN81956Blue Skies Leasing Inc · Port Orange, FLN8195AMundorf John P · Mullen, NEN8195DGray Richard B · Manley Hot Springs, AKN8195EKummer Richard L · Dallas, TXN8195WN7396w LLC · Coeymans Hollow, NY
Back to AD 90-04-06 R1