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.
N6027CShough Mark E · Bemidji, MNN6027DSnyder Logan J · Wasilla, AKN6027PJourney Over Destination Aviation LLC · Golden, CON6027QBergh Robert P · Hammett, IDN6027ZSpacely Space Sprockets LLC · Aurora, ORN6028CPopejoy Gregory M · Sacramento, CAN6028QSky Partners LLC · Sylacauga, ALN6028XHarnagel Duard R · Scottsdale, AZN6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRN6029BSchmidt Glenn J · Wesley Chapel, FLN6029DRonnie L Tremain · Sherwood, ORN6029QHill John T · Saint Augustine, FLN6029WWalsh Robert D · Somerset, CAN602AKimberlin Lisa · San Francisco, CAN602BCN602bc LLC · Wasilla, AKN602CBWray David A · Louisville, KYN602CPCivil Air Patrol · Maxwell Afb, ALN602DTFollow Your Bliss LLC · Woodbury, MNN602EPJones Theodore R · Prospect, KYN602EREmbry Riddle Aeronautical University Inc · Prescott, AZN602FLRoberts David R · West Newton, MAN602FTFlorida Institute Of Technology · Melbourne, FLN602HKing John H · Trumansburg, NYN602JAAllen John S · Pasadena, CAN602JYN13303 LLC · Miami, FLN602NDRainer Flight Service LLC · Renton, WAN602PCJ & P Aviation LLC · Plymouth, MAN602RVQuick Comfort Inc · Allen, KSN602TLCoast Flight Training And Management Inc · San Diego, CAN602TPChemic Plane LLC · Grand Rapids, MIN602TWChrysalide LLC · Oklahoma City, OKN602UTecnam US Inc · Sebring, FLN602WKStrange River Inc · Dripping Springs, TXN602WTCary Steven B · Brookshire, TXN602ZRegistration Pending · Mullica Hill, NJRegistration pendingN6030CJames Marvin L · Scio, ORN6030DKnipper Larry R · New Lenox, ILN6030FAmeriflyers Of Texas Inc · Addison, TXN6030PAngel Aviation LLC · Paradise, KSN6031DCeruto Jorge · Auburndale, FLN6031EHigh Exposure Inc · Wilmington, DEN6031FAmeriflyers Of Texas Inc · Addison, TXN6031LRegistered aircraftN6031QWhittier Frank · Las Vegas, NVN6031WWings Over Texas Holdings LLC · Denton, TXN6032DBravo Gulf Zulu Aviation LLC · Newark, DEN6032PStarrynight Bonanza Group LLC · Brighton, CON60337Lewis University · Romeoville, ILN6033A3v Global LLC · Clermont, GAN6033FSky View Aviation LLC · Benton, KY
Back to AD 81-18-04 R2