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.
N88477Holland William T III · Midway, ARN8847CBlumenberg Donald D · Fulton, SDN8847FNeitzer Robert W · Milwaukee, WIN8847JFlw LLC · Sandpoint, IDN8847MTravel Air LLC · Chico, CAN8847NMcdougal Thomas K · Woodward, OKN8848CLeppert James J Trustee · Dickey, NDN8848JMegaw George C · Fort Lauderdale, FLN8848NPro Tech Aviation LLC · Corona, CAN8848YBrunot Frank A · Spring Hill, FLN88497Airspace Aerial Media LLC · Saint Louis, MON8849CFitts David A · Salem, ORN8849JBailey Aviation Company LLC · Little Rock, ARN8849NCafran Lloyd V · Youngsville, NCN884ATDot Aviation LLC · Wilmington, DEN884CAColeman Aero Club · Apo AeN884DJohnson David L · Blaine, MNN884DCTanner Greg L · Bend, ORN884EFChudy Zbigniew P · Southington, CTN884FTFlorida Institute Of Technology · Melbourne, FLN884JSCrane John R · Niceville, FLN884MWWarfel Michael G · La Verne, CAN884PSSpainhower Paul Allex · Taylorsville, UTN884RVDannebrock Paul W · Lockport, NYN884SADamico Frank J · Pittsburgh, PAN884WGVandermay Brandon · Winnemucca, NVN8850NGregs Airplane Rental LLC · Eloy, AZN8851JMoore Jeffrey A · Lawrenceburg, TNN8851NBloodworth Nathan B · Hendersonville, TNN8852CWobken Mark E · Orange, CAN8852LFederman Cecilia · Beaumont, CAN8852YWikle Luther M · Laceys Spring, ALN8853DSlaughter Don Wayne · Farmville, NCN8853JN8853j LLC · Oak Park, ILN8854CMid Continent Aircraft Corp · Hayti, MON8854DKidd Clifford L Jr · Monahans, TXN8854LPfs Air Inc · Yellville, ARN8854YSeeds John S Jr Trustee · Tequesta, FLN88553Riggin Flight Service Inc · Madison, SDN8855NIndy Distributors Inc · Noblesville, INN8856CBritton Mark W · Wasilla, AKN8856FRotorcraft Unlimited LLC · Brooksville, FLN8856JFifty Six Juliet LLC · West Lafayette, INN8856LRuales Edison R · Miami, FLFirst renewal noticeN8856NGrant Shane J · Cape Coral, FLN8857Aviation Management Systems LLC · Fallbrook, CAN8857CValkenburg Toby · Anchorage, AKN8857DHollan William E Jr · Winston Salem, NCN8857JNguyen Tu K · Costa Mesa, CAN8857MDunn Brady · Gilmer, TX
Back to AD 90-04-06 R1