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.
N64186Paraloft LLC · Mims, FLN6418DAirways Aviation Inc · Grand Rapids, MNN6418ELima-001 LLC · Muscatine, IAN64191Flycarolina LLC · Concord, NCN64192Skyhawk Transport LLC · Hazel Green, ALN64198Randy Goering Inc · Bend, ORN64199Mutschler George Robert Jr · Bayfield, CON6419JMathis Charles D · Carrollton, GAN6419LHaag Jay E · Mason City, IAN6419MWings Over Texas Holdings LLC · Denton, TXN6419QFranklin Brian K · Lakewood Ranch, FLN6419VUrbana Aircraft LLC · Urbana, MDN641BStoddard Robert James · Brush Prairie, WAN641CCClub Cherokee Inc · Crystal, MNN641DHFisher Russell D · Vacaville, CAN641FTFlorida Institute Of Technology · Melbourne, FLN641GWSnyder Jerry W · Greybull, WYN641HYGerges Amir · Arlington, TXN641MAAscent Aviation Inc · Duluth, MNN641PPhilip Mark A · Leesburg, VAN641PSSmith Michael J · Napa, CAN641PTPapa Tango LLC · West Monroe, LAN641RHJakes Guide Service LLC · Willow, AKN641RVDavies Chris D · Caddo Mills, TXN641SManning Robert S · Rosamond, CAN641SPRhode Island Air LLC · Providence, RIN641TDDornseif Keith · Merrillville, INN64201Registration Pending · Lander, WYRegistration pendingN64203Vance Nicholas D · Bluffton, OHN64209Kay Roland C · Wasilla, AKN6420JPomerenke Tyler J · Fairmont, MNN6420MJensen Aviation Inc · Zephyrhills, FLN6420QKelley Richard E · Spring Branch, TXN6420ULambert Glen C · Las Vegas, NVN6420VKorson James · Yorkville, ILN64213Ajc Aviation LLC · Boca Raton, FLN64215Registered aircraftN64217Simplifly LLC · Mesa, AZN64219American Patrols Inc · Midland, TXN6421JShoemaker Kent L · Renfrew, PAN6421QShine Christopher A · Mammoth Lakes, CAN6421UAlpha 1 Aviation LLC · Helena, ALN6421WTyde Arthur F III · Los Angeles, CAN64220Wieman Dianne L · Marion, TXN64224Smith Aviation LLC · Springer, OKN64228Abbott Cedric M · Buckfield, MEN6422JSuncoast Aviators LLC · Odessa, FLN6422QHoward Mac · San Marcos, TXN6422RYang Chi · Lafayette, CON6422WDomler Michael R · Gilroy, CA
Back to AD 90-04-06 R1