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.
N4755PJet & Rotor Aviation LLC · Sacramento, CAN4755ZHerold Dana R · Mcminnville, ORN47560Vy Aviation LLC · Beverly, MAN47562Screen Printing USA Inc · Plymouth, PAN47563Mike Mooney Construction LLC · Wilmington, DEN47564Orourke James K · Omaha, NEN47567Jordan Clifford A · Woodbridge, VAN4756GOliver Randy M · Limerick, MEN4756JEhling Joseph P · Snohomish, WAN4756LJones Tyler J · Williamsburg, KYN47578Donair Inc · Toledo, OHN47579Gomed Air LLC · Greenville, SCN4757DCalhoun Gerrald E · Leesburg, FLN4757LMil2atp Inc · Pikeville, NCN4757YLake Country Lodge · Port Alsworth, AKN4758Butler David Michael · Seattle, WAN47580Sky West Aviation Inc Trustee · Albuquerque, NMN47582Beckham Jackie D Trustee · Coyle, OKN47587Neel Aviation LLC · Lakeland, FLN4758FPhastar Corp · Cleveland, OHN4758JFardell Christopher J · Gilbert, AZN4758LStouffer Michael L · De Soto, ILN4758ZMcgirr Kenneth L · Huron, SDN47595Tappendorf Dan · Florence, ALN47599N47599 LLC · Senoia, GAN4759JPersons Jonathan B · Eagan, MNN4759LPc 180 LLC · Lincoln, NEN4759TPasricha Sarosh K · Swedesboro, NJN4759ZKeib Frederick N · Lowville, NYN475ACWigginton John D · Saco, MEN475AHBoatman John H Jr · Smyrna, TNN475ATAirmen Testing And Training Inc · Lantana, FLN475CJKing Charles Douglas Sr · Silsbee, TXN475DSLevi Davis LLC · Gratiot, WIN475FBHentges Henry J · Jefferson City, MON475GPBig Sky Communication & Cable Inc · Billings, MTN475KKmt Aviation LLC · Centerville, OHN475NZeiler Richard Trustee · Thousand Oaks, CAN475PCSaint Louis University · Saint Louis, MON475PSInosculation 2 LLC · Summerville, SCN475TFV1 Capital Advisors LLC · Boca Raton, FLN475TVPaine Twin Comanche LLC · Redmond, WAN475WDickerson Harman · Columbia, MON475WDWilloughby Dan J · Linden, MIN47600Stukus David · Exeter, RIN47601Phoenix Flyers Inc · Mesa, AZN47603Kor Joshua · Montgomery, MNN4760AMcgarrh James R III · Byhalia, MSN4760HBrh Aviation Inc · Indianapolis, INN4760LSouthern Utah University · Cedar City, UT
Back to AD 90-04-06 R1