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.
N564MTMiddle Tennessee State University · Murfreesboro, TNN564PCHargest Custom Cabinetry LLC · Clermont, NJN564PUPurdue Aviation LLC · West Lafayette, INN56500Bas Part Sales LLC · Greeley, CON56501Hair Heather D Trustee · Bonner, MTN56506Nassour Aviation Inc · Ellisville, MSN5650JWaypoint LLC · Fairbanks, AKN5650PSlayton Paul · Roswell, NMN5650QOrtland Richard James · Franklin, MIN5650RWaco Air LLC · Wolfeboro, NHN5650SOliver Jonathan · Maryville, TNN5650USkyways Group LLC · Greensboro, NCN5650WRwk LLC · Anchorage, AKN56515Norcross James H Jr · Homer, AKN56517Andrews Paul · Chugiak, AKN56518Cpf Money Processing Systems Inc · Spokane, WAN5651BRoland David K · Lockhart, TXN5651DWhisper Lake Flair Corp · Soldotna, AKN5651EMrzena Matthew D · Wasilla, AKN5651HCramer Nicholas R · Lexington, OHN5651NEllett Robert T IV · Brookhaven, GAN5651PSeremet Cristina L · Beaver Dam, WIN5651QKingdom Air LLC · Diamondhead, MSN5651VBecker Florian Alexander · Fort Lauderdale, FLN5652Leary Brian J · Fredricksburg, PAN56520Mt Aircraft LLC · Port Orange, FLN56521Hawkes Tyler · Rexburg, IDN56524Registration Pending · West Palm Beach, FLRegistration pendingN56525Sadi Susan Salimi · Arlington, TXN56526Registered aircraftN56528Delzer James K · Sanger, TXN56529Jilek Peter A · River Falls, WIN5652CRegistered aircraftN5652ECgumps LLC · Antioch, TNN5652HKerby Ryan S · Talkeetna, AKN5652LSkelton Thomas Nichols Jr · Jackson, MSN5652NMaule Airways Inc Trustee · Wilmington, DEN5652ULions Flyers Inc · Enterprise, ORN5652WDamazo Kimber P · Portland, ORN5652ZClifford Karl N · Lubbock, TXN56536Hurlbut Gary A · Seattle, WAN5653LUlpiano Amy · Carolina, PRN5653PBeasley Charles R · Lumberton, NCN5653RSchoenau Michael · Tulare, CAN5653UMcclelland Robert C · La Veta, CON5653WCrump William J · Williamstown, NJFirst renewal noticeN56545Sauder Richard J · Evergreen, CON56547Schroeder Gordon D · New Braunfels, TXN5654BStol-Air LLC · Salem, ORFirst renewal noticeN5654DMiller Arlyn E · Boise, ID
Back to AD 81-18-04 R2