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.
N709DFGregoire Aviation Services LLC · New York, NYN709GCareer Pilot Training LLC · Wilmington, DEN709LAN709la LLC · Philadelphia, PAN709MWGrant Michael R · South Weber, UTN709RVOliveira John S · Port Townsend, WAN709RWHogan David G · Urbandale, IAN709SCRunamuck LLC · New Orleans, LAN709WBBowman Stephen L · Palm Bay, FLN70ABVastola Alex G · Conroe, TXN70AHForden Noah P · Saunderstown, RIN70BDRegistration Pending · El Paso, TXRegistration pendingN70BTBurg Robert L · Fairbanks, AKN70BZFaibisoff Isaac J · Caseyville, ILN70CDLewis Cherrie · Hampton, CTN70CEBandit Soaring LLC · Gig Harbor, WAN70DMartin Ernest · Sandpoint, IDN70EF720 Degrees Inc · Santa Monica, CAN70EPMccain William A · Jackson, MSN70FGPears Aviation Corp · Kissimmee, FLN70GBVinter Mooney LLC · Philadelphia, PAN70GDBig Bend Soaring Inc · Port Orange, FLN70GKScott Archer LLC · Scott City, KSN70GLShillieto Gordon W · Burlington Flats, NYN70GSDavis Jeffrey W · Thomasville, NCN70GTTaylor Gary T · Ontario, ORN70GVWeidner Melvin · Elk Grove, CAN70HALong David A · Yamhill, ORN70HFCavorite Aviation LLC · West Jordan, UTN70HUHexom Nathan · Bozeman, MTN70HYHigher Powered Racing LLC · Port Saint Lucie, FLN70JFFuller Eddy A · Madras, ORN70JHBlythe Anne T · Paso Robles, CAN70JXRunway Optional LLC · Fergus Falls, MNN70KDN70kd Research & Development LLC · Keller, TXN70KPPrichard Kevin L · Enterprise, KSN70LMIrving Mark S · Cordova, AKN70MHN70mh LLC · Wilmington, DEN70MPWhitewater River Runners LLC · Wilmington, DEFirst renewal noticeN70NGGriffin Bernard · Peckville, PAN70NTTaylor Margaret L Trustee · Ontario, ORFirst renewal noticeN70PFSwaz Aviation LLC · Mesa, AZN70PWStoner Tommy E · Kennesaw, GAN70REHendricks Field Aviation LLC · Sebring, FLN70RPPulis John · Willis, TXN70RVDonovan Gerald A · Los Lunas, NMN70RWHines Thomas J · Anchorage, AKN70SFFred Stuart L · Houston, TXN70SHGarmin International · Olathe, KSN70SRBray Max W · Dora, ALN70SUOhio State University · Columbus, OH
Back to AD 90-04-06 R1