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.
N6458JFlorida Tectonics Inc · Weirsdale, FLN6458LCentral Texas College · Killeen, TXN6458PHutchison Joseph C · Mebane, NCN6458VWilson David P · Lumberton, TXN6458WJones Larry · Clovis, NMN6459LFalcon Financial Solutions · Meadow Vista, CAN6459PJaeger Timothy S · Mukwonago, WIN6459RLogical Drive Inc · Siler City, NCN6459ULinck Market Inc · Little Rock, ARN6459WBillingsley Littleton C Jr · Spicewood, TXN645AWHobart Aviation Inc · Akron, OHN645CHWebster Jason M · Orlando, FLN645DBBailey Dennis L · Oakdale, CAN645DDAmes Donald L Trustee · Park City, UTN645DTScenic Mountain Air Inc · Moose Pass, AKN645EJFogelin Eric S · Shasta, CAN645EPChristiansen Aviation LLC · Wilmington, DEN645FCFlorida Dept Of Agriculure & Consumer Services · Tallahassee, FLN645FLRule Charles Y · Mineral Point, WIN645FTFlorida Institute Of Technology · Melbourne, FLN645KAHelocraft Holding Co Inc · Pembroke Pines, FLN645LCJohnston Laura S · Seattle, WAN645MMikkelsen Timothy O · Wasilla, AKN645NDUniversity Of North Dakota · Grand Forks, NDN645PAzul Services LLC · Bozeman, MTN645RD&S Development LLC · Spring, TXN645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTN645RFHagge Hal E · Eagle River, AKN645SStewart Dennis M · Fernley, NVN645SAGerrish Ronald M · San Antonio, TXN645SDDacy Julia A · Harvard, ILN645SPRegistration Pending · Bennett, CORegistration pendingN645XAzul Services LLC · Bozeman, MTN645ZAzul Services LLC · Bozeman, MTN64608A S Air LLC · Lantana, FLN6460DVan Wagner Aerial Media LLC · Hollywood, FLN6460LRichmor Aviation Inc · Scotia, NYN6460MHillsboro Aero Academy LLC · Hillsboro, ORN6460PAlpha Romeo Kilo Holdings Inc · Wilmington, DEN6460QDel Gado Raul L · Victorville, CAN6460TDavey Douglas H · Worley, IDN6460UHayes Toby G · Idaho Falls, IDN64611Great North Air LLC · Shelburne, NHN64617Melbourne Flight Training LLC · Melbourne, FLN6461CTripacer Strategic Consulting LLC · Dover, DEN6461PSullenger Charles H · Statesboro, GAN6461QGanos Christ · Brookfield, WIN6461RBetsy N6461r LLC · Novato, CAN6461VRegistered aircraftN6461WOverstreet Aviation LLC · Sunray, TX
Back to AD 81-18-04 R2