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.
N942TECardinal Enterprise LLC · Jackson, WYN942VTMcintosh Donald W · Sandpoint, IDN942WGPotter Mark H · Santa Rosa, CAN9430LArnason Matthias J · Portland, ORN9430NOakley Air LLC · Oakley, MIN9430VRuff Deborah · Auburn, CAN9430W3zero Whiskey LLC · Newport Beach, CAN9431COsgood Air LLC · Ransom, KSN9431JCurrie Kenneth Edward · Lumberton, NCN9431LCordova Zachary · Brighton, CON9431TDavis Gary L · Burleson, TXN9432DRegistered aircraftN9432LMendelson Edward · Philadelphia, PAN9433DPacer Flight LLC · Huron, OHN9433EKozma Peter · San Diego, CAN9433JSierra Delta Aviation Services Inc · Middletown, DEN9433LCivil Air Patrol Inc · Maxwell Afb, ALN9433RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9433WSanford William M · Olalla, WAN9434JSchmidt Matthew F · River Falls, WIN9434VKnackstedt Dennis R · Winfield, KSN9434WJohnson James E · Calhoun, LAN9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeN9435JHarmon Daniel J · Sheridan, INN9435LHubbell Aerin B · Mccordsville, INN9435NDoran Jeffrey · Centerburg, OHN9435WPace Lawrence W · Westminster, CON9436WGiesbrecht Harley L · Deridder, LAN9437DRichmor Aviation Inc · Scotia, NYN9437JGarba Ibrahim I · Boulder City, NVN9437LMurrell George E · Glendale, AZN9438DWeidner Kevin G · Bunker Hill, ILN9438HBering Capital LLC · Anchorage, AKN9438LM & B Blue Sky LLC · Southlake, TXN9438VPrestridge Jacob · Portland, ORN94397Koenitzer Judson B · Chetek, WIN9439BAv Dak Inc · Crystal, NDN9439ESilverhawk Aviation Academy LLC · Caldwell, IDN9439HTreichler Peter DBA · East Aurora, NYN9439KAirspeed Marketing Bravo LLC · Phoenix, AZN9439LCheung Patrick · Boca Raton, FLN9439WCherokee Ltd LLC · Mesa, AZN943CPCivil Air Patrol · Maxwell Afb, ALN943GDowning John Brent · Castro Valley, CAN943KSStark James E Trustee · Sun City, AZN943MAMiller Joseph T IV · Bethel, NCN943NDUniversity Of North Dakota · Grand Forks, NDN943RVShea Tim M · Pearland, TXN943SASunrise Aviation Inc · Ormond Beach, FLN943SPLittle Airplanes LLC · Aurora, OR
Back to AD 81-18-04 R2