AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7458JReeves Stephen · Watford City, NDN7458KMy Piper Pacer LLC · Everett, WAN7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN74590Registration Pending · Barry, TXRegistration pendingN74591Tiger Aero LLC · Beresford, SDN74592Higgs III Cyrus H · Jackson, TNN74593Sandlin Jesse L · Chesterfield, VAN74594Pinger Kevin R · Palo Alto, CAN74595Ehrhard Robert A · Jasper, INN74596Cato James W · Las Cruces, NMN74597Airman Helicopter Inc · Fort Lauderdale, FLN74599Fletchair Inc · Comfort, TXN7459JEvans Charles Dewayne · Cumby, TXN7459LStewart Martin J · Anchorage, AKN745BPlanelease LLC · Venice, CAN745BACsa Aircraft Leasing LLC · Salt Lake City, UTN745CPCivil Air Patrol · Maxwell Afb, ALN745CWKnight Verl D · Caldwell, IDN745DCN745dc LLC · Kennesaw, GAN745EREmbry-Riddle Aeronautical University Inc · Prescott, AZN745FWWalther Frank C · Crawford, CON745GCHill Jack C · Arnold, MON745LMMurley Stephen L · Boerne, TXN745LSWeaver Chris D · Hallam, NEN745MSSchamel Michael A · Salem, INN745NDornoch Services LLC · Dover, DEN745NDUnd Aerospace Foundation · Grand Forks, NDN745PASkywest Leasing Inc · St George, UTN745RAAri Ben Aviator Inc · Fort Pierce, FLN745SPBanks Douglas Trent III · Huntsville, ALN745TWTumbleweed Leasing Co Inc · Salt Lake City, UTN745UDornoch Services LLC · Dover, DEN745ZZin Services LLC · Dover, DEN746Hall Gary L · Delta Junction, AKN74600Tiger Flight Corp · Wilmington, DEN74602November Alpha LLC · Dover, DEN74606Spitzer Helicopter LLC · Woodland Hills, CAN74608Palmer Thomas R · Vincent, OHN7460DJohnston Stephen P · Hawley, MNN7460LLeoni Eric D · Boulder, CON7460PStevenson George Otis · Wheatland, WYN7460ZSimmons Aviation Services LLC · Pawcatuck, CTN74611Hahn Jordan A · Orcutt, CAN74613Lindstrom Richard T · Castro Valley, CAN74614Bikerman David J · Old Savbrook, CTN74619Specialty Aerospace LLC · Grand Rapids, MIN7461GKniphfer Krenson Hunter · Newington, GAN7461RIngram John · Tulsa, OKN7461WSdflysc LLC · Mauldin, SCN74620Columbia Flying LLC · Columbia, SC
Back to AD 81-18-04 R2