AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N29022Unifly Inc · Lackawanna, NYN29059Ens Aviation LLC · Marshall, TXN29061Swalling Frederick M · Anchorage, AKN29068Jd Flying LLC · Bellingham, WAN29084D E C Holdings · Hansen, IDN29110Sutton Aircraft Salvage LLC · Palmer, AKN29113Figueroa Angel Lara · Winfield, ALN29114Grey Goose LLC · Wasilla, AKN29127Shivers William L Jr · Friday Harbor, WAN29130Ernst Gregory R · Eagle Creek, ORN29138Allen Brent H · Mammoth Lakes, CAN29142Hall Darryl Wayne II · Wasilla, AKN29151Inland Aerial Surveys Inc · Riverside, CAN29164Iturriria John · Kuna, IDN29173Aerial Transport LLC · Wilmington, DEN29176Tgr Helicopters · Fresno, CAN29181Wings Of Faith · Stevensville, MTN29186Thoroughbred LLC · Kalispell, MTN29188Rugger Investment Group LLC · Tustin, CAN29190Mountain Helicopters LLC · Salt Lake City, UTN29204Jms Aviation LLC · Waynesville, OHN29209Bas Part Sales LLC · Greeley, CON29210Hawkes Brian R · Hamilton, MTN29217Dawson Adam J · Eveleth, MNN29224Phelan Ricky Ray · Jefferson, ORN29278Pancho Moreno Y La Flaca LLC · Camuy, PRN29289Disarro Wayne · Wasilla, AKN29292Skytime Aviation LLC · Tulsa, OKN29299Svetic Russell T · Redondo Beach, CAN29359Cervantes Jose DBA · San Diego, CAN29542Giannakakis Peter J · Monroe, MIN295FAStationair Amphib LLC · Jefferson City, MON29631Registered aircraftN29674Snflk Leasing LLC · Andrews, TXN297DRMingus Mason · Scottsville, KYN297ZEnovi LLC · Las Vegas, NVN29FCUsda Forest Service Fepp · Raleigh, NCN29PMAlly Mohamed Yacoob · Fort Lauderdale, FLN2DMWiley Post LLC · Lewes, DEN2KDElliott Frank F · Mojave, CAFirst renewal noticeN2RXJbs Enterprises LLC · Hamilton, MTN2SLLowe Aviation LLC · Bountiful, UTN2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEN2YROverland Missions Inc · Cocoa, FLN30038Stockyard LLC · Wilmington, DEN300EW2f Trade LLC · Collinsville, TXN300HCPs Air LLC · Evansville, INN301EBQuesnel William G · Truckee, CAN301RS2f Trade LLC · Collinsville, TXN30268Rudd Terry R · Clarkston, WA
Back to AD 2002-07-01