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.
N7397BAerolina Inc · Hendersonville, NCN7397GMarkowitz Edwin P · Luray, VAN7397JJmk Repair · Lone Oak, TXN7398Weston Weed Control LLC · Weston, WYN73981Gagnon Michael J · Merrimack, NHN7398JGreat Lakes Aviation Services LLC · Kimball, MIN7398LNelson Gregory J · Newcastle, CAN7398WJil Aviation Inc · La Coste, TXN7399JGordon Jacob M · Tega Cay, SCN7399WI Was Inverted LLC · Fort Myers, FLN739ADSeven Three Nine Alpha Delta Club Inc · Memphis, TNFirst renewal noticeN739AFSilver Isaac M · Satellite Beach, FLN739AGS O W Aviation LLC · Crystal River, FLN739AJAviation Adventures LLC · Billings, MTN739AKChen Wu · West Windsor, NJN739AMBartels Michael · San Antonio, TXN739APMilwaukee Aero LLC · Milwaukee, WIN739AQAzure Mahpiya LLC · Dublin, CAN739ATSocal Aviation Inc · Chino, CAN739AVMk914 Aviation LLC · Boynton Beach, FLN739AWOsborn Lawanda H · Weatherford, TXN739BCSecond Wind Aviation Corp · Friday Harbor, WAN739BEFtg Leasing LLC · Watkins, COFirst renewal noticeN739BJDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN739BKSundown Robert W · Bethel, AKN739BNR&R Aero Services LLC · Eden Prairie, MNN739BTBoeing Employees Flying Assn Inc · Renton, WAN739BVBurgol Hisham · Novi, MIN739BXSkypark Inc · Wadsworth, OHN739BZTfs Air LLC · Loveland, CON739CCCitadelle Holdings LLC · Wilmington, DEN739CDKcsi Aerial Patrol Inc · Bakersfield, CAN739CMHansen Lee A · Faulkton, SDN739CNAerobiz LLC · Lewes, DEN739CYTodd Goven Farms Inc · Turtle Lake, NDN739CZBullock Michael L · Albany, INN739DBMelbourne Flight Training LLC · Melbourne, FLN739DDRivera Carlos R · Carolina, PRN739DEWings Over Texas Holdings LLC · Denton, TXN739DFMorcom Aviation Services Inc DBA · Everett, WAN739DJKemp Kerm R · Southwest Ranches, FLN739DPMoler Darryll M · Mount Orab, OHN739DRCenterline Holdings LLC · Belgrade, MTN739DTWheelair Inc · Fairfield, CAN739DWKayo Air Service Inc · Harlingen, TXN739DXRegistration Pending · Glendale, CARegistration pendingN739DZFerrari Thomas J · Torrance, CAN739EAVpc Air Inc · Cartersville, GAN739EFDyberg Mike · Mount Vernon, WAN739EHDairy Air Inc · Wyoming, PA
Back to AD 90-04-06 R1