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.
N5369HValdiosera Octavio · Tracy, CAN5369RArmbruster LLC · Amherst, OHN536AScgi Inc · Griffin, GAN536CBZelner Gregory · Merritt Island, FLN536DShiloh Aviation LLC · Ramer, TNN536GTNorthern Planes Aerosport LLC · Algona, IAN536JRSale Reported · Port Orange, FLSale reportedN536MAWilliams Fertilizer Services LLC · Oregon, MON536MMTroyer David · Newnan, GAN536PUMetro Aircraft Co · Bloomington, MNN536SN5405a LLC · Beverly Hills, CAN536XDel Rio Aviation Inc · Paso Robles, CAN53703University Of Michigan Flyers Inc · Ann Arbor, MIN5370FRegistered aircraftN5370HGodec David E · Waunakee, WIN5370LSouthern Colorado Flight Professionals LLC · Pueblo, CON5370TK.M. Biggs Inc · Lumberton, NCN5370WAllen Lanny Dean · Indianapolis, INN53713Haley Wendell B · Williamson, GAN53718Seals James E · Oxford, ALN53719Allen Scott P · Wellington, NVN5371HMacdonald Randall N · Weidman, MIN5371KExecutive Aviation LLC · Peoria, AZN5371QTimber Creek Flyers Lc · Albion, IAN53720Christiansen Aviation LLC · Wilmington, DEN53723Garthus Nels · Grafton, WIN53724Hackamore Equipment LLC · Prairie City, SDN53725Registration Pending · Honolulu, HIRegistration pendingN53726Bower Jessica L · Oshkosh, WIN53728Stinecipher Wilson C · Wasilla, AKN5372VCooper'S Hawk Aviation LLC · Rochester, MIN53730Vance Jason · Lufkin, TXN53735Vermont Flight Academy · South Burlington, VTN53737Diloreto Gregory T · Jupiter, FLN53738G&G Equipment LLC · Wasilla, AKN5373HMoore Jeffrey D · Blossvale, NYN5373LDavies Patrick · Chula, GAN5373THorizon Aviation LLC · Brooks, GAN5373YBush Dan S · Wasilla, AKN53740Gardner Robert J · Orwigsburg, PAN53742Mh Aviation Inc · Lancaster, CAN53744Tango Echo Aero LLC · Holly Lake Ranch, TXN53745Speth Kerry G · Oak Harbor, WAN53746Apollo 18 LLC · Tipp City, OHN53747Tenkey Investments LLC · Tulsa, OKN5374JMiles Brian R · Lake Jackson, TXN5374KApex Aircraft Leasing LLC · Anchorage, AKN5374LLund Chris J · Williston, NDFirst renewal noticeN5374TWeaver Stephen E · Enon, OHN5374ZMyers Kenneth Jerome · Haines, OR
Back to AD 90-04-06 R1