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.
N4636ZJenkins Thomas L III · Perry Park, KYN46374Marcotte Jeffrey N · Bossier City, LAN46378Northwoods Air LLC · Levant, MEN4637GAbove All Aviation Inc · Santa Barbara, CAN4637JVijayan Priya · Mckinney, TXN4637RFly Me LLC · Sparta, TNN4637VChristian Swann & Associates Inc · Peachtree City, GAN4637WBrimmer Kyron · Encinitas, CAN46381Oldis Frank A · Taylors, SCN46382Cognition LLC · Billings, MTN46385R A Marsh Flying Club LLC · Williamson, GAN4638JChappel Dexter A · Palm Coast, FLN4638VRegistration Pending · Olympia, WARegistration pendingN4638WHavens Todd · Airway Heights, WAN46390Gerber Aviation LLC · Winter Haven, FLN46391Stark Rickie N · Princeton, MNN46392Tedron Air Ltd · Setauket, NYN46393Sam Aviation LLC · Long Beach, CAN46396Kpa LLC · Kalamazoo, MIN46399Rutter Clarence W III Trustee · Norman, OKN4639RSterling Flight Training LLC · Jacksonville, FLN4639VRunway 7 LLC · Lewes, DEN4639WValiair Lc Trustee · Casper, WYN4639YRegistered aircraftN463ATriggs Robert · Lubbock, TXN463CMUniversity Of Central Missouri · Warrensburg, MON463DGZhong Yu · Henderson, NVN463DMGresham Stanley W DBA · Ironwood, MIN463FAStratus Rr LLC · New Castle, DEN463RNDave Aviation LLC · Naperville, ILN463RVSumma James A · Dallas, TXN463SPRegistered aircraftN464Trn Aviation LLC · Lewes, DEFirst renewal noticeN46401Bandstra Larry J · Heath Springs, SCN46404Coastal Fliers Inc · El Cajon, CAN46407Solis Joseph G · Poulsbo, WAN4640BChapel Hill Flying Club DBA · Sanford, NCN4640J4 Flyers Inc · Norwood, NYN4640PBarger Gary L · Asheville, NCN4640RSchotter Robin J · Seattle, WAN4640VHbhis LLC · Gnadenhutten, OHN4640WBerger Adam · Kanab, UTN4640ZGent Richard · Lancaster, TXN46410Valentine Terence · Glennallen, AKN46413Wings Over Texas Holdings LLC · Denton, TXN46415Hage Michael J · The Villages, FLN46418Batesquire LLC · Clanton, ALN46419Rodgers Bruce W · Ramona, CAN4641JN4641j LLC · Mulberry, FLN4641PRiverside Flight Center Inc · Tulsa, OK
Back to AD 90-04-06 R1