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.
N5139TRatliff John B · Oroville, CAN5139XGlatthaar Richard J · Burbank, WAN5139YB & B Equipment Inc · Cantwell, AKN5139ZKnarr Perry Lee · Lock Haven, PAN513AFVee Two Inc · Merritt Island, FLN513BLWingsleasing LLC · Wichita, KSN513BWRegistered aircraftN513DNNowakowski Donald K Trustee · Gilbert, SCN513JCMathis Joshua D · Mitchell, INN513JSFox John R · Lansing, KSN513MSteuber Edward P · Erwin, TNN513MMGlacier Peak Aviation LLC · Carnation, WAN513MSPark Brian Byung · Anaheim, CAN513PCBaklanov Sergey I · Whitestown, INN513PUBrosemer Kathleen M · Sault Sainte Marie, MIN513RJGurski Robert C · Lees Summit, MON513RMRosen Larry M Trustee · Santa Barbara, CAN513SPPlane Old Inc · New York, NYN513TRGonzalez Miguel A · Pembroke Pines, FLN51403Remigy Mathias E · Peterborough, NHN5140BSesnic Aidan · Mukilteo, WAN5140ESadosky Paul · Glendale, WIN5140GDippolito Mario M · Sherwood, ARN5140QMccoy David J · Perryton, TXN5140RAshby Artie Dale Jr · Madison, ALN5140VSale Reported · Grafton, VTSale reportedN5141KGilbertsville Flying Service LLC · Gilbertsville, PAN5141LEnnis Brian K · Lizella, GAN5141RServant Air Ministries Inc · Merritt Island, FLN5141WOldakowski Kathleen A · Owls Head, MEN51422Inman Mitchell F · New Waverly, TXN5142HThistle Richard J · Wasilla, AKN5142LRaider Aviation LLC · Lubbock, TXN5142SRossow Eldon F · Fort Dodge, IAN5142WPacific Northwest Aeronautics Inc · Port Orchard, WANon-citizen corporation, flight hours not reportedN5142ZFlorey Carl L · Eureka, MTN5143WDager Steffen M · Milan, NHN5143XHardin John W · Fort Myers, FLN5143ZHonkala Michael R · Wasilla, AKN51448Haley Robert · Livermore, CAN5144BCloud Dancer Aviation Inc · Deland, FLN5144LEmpire Aviation · Oxford, NCN5144RBuffalo Flying Club Inc · Ayr, NDN5144SWorth Frank · Bakersfield, CAN5144TAir Trac Inc · Pasco, WAN5144VKlein Bruce R DBA · Port Allegany, PAN5144WHub City Aviation Academy LLC · Lubbock, TXN5144XSkywest Leasing Inc · St George, UTN5144ZUlrich Kenneth B Jr · Kingwood, TXN5145ESierra Pacific Aviation · Willits, CA
Back to AD 90-04-06 R1