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.
N8919JKelly Kevin R · Ormond Beach, FLN8919VChristiansen John · Vicksburg, MIN891CPCivil Air Patrol · Maxwell Afb, ALN891DBSpivak Maxim · San Jose, CAN891DDDiehl James W · Williamsport, PAN891GPHancock Aircraft Sales LLC · Baton Rouge, LAN891MDCharbonneau John E · Manhattan, KSN891NDUniversity Of North Dakota · Grand Forks, NDN8920DReese Larry H · Raytown, MON8920JSargent Timothy E · Pickerington, OHN89215Delgado Ruben E · San Antonio, TXN8921DPetterson Jason G · Albert Lea, MNN8921RPotters Aviation LLC · Haskell, OKN8921VN2827n LLC · Pembroke Pines, FLN8922Culver Marc D · Anchorage, AKN89225Lucky Dog Aviation LLC · Victoria, TXN89226Hillsboro Aero Academy LLC · Hillsboro, ORN8922DHassell Clark R · Ketchikan, AKN8922JTowner Jeffery D · Rose Hill, KSN8922VTampa Bay Aviation Inc · Clearwater, FLN8923Brockway Troy D · Salina, KSN8923DWood Rhonda R · Livermore, CAN8923JVenture West LLC · Mesa, AZN8924CHaines Delmar W · Rolla, MON8924DHickey Aero Services LLC · White Hills, AZN8924RMachler Lance J · Murphys, CAN8924VDupree Johnny · Crossett, ARN8924WRiblet Jeffrey L · Portsmouth, VAN8924YPrestininzi Robert Anthony · Fort Mill, SCN8925FAztec Aviation · Geneseo, ILN8925YBlue Sky Adventures LLC · Hanover, PAN8926Johnson David H · Jasper, GAN8926DPlanes & Things Inc · Collinsville, OKN8926JGreene Ronald F · Mc Alpin, FLN8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLN89273Anderson Ben H · Fort Smith, ARN8927JTipton Thomas G · Walnut Grove, MON8927PSmith Tracy L · Middletown, CTN8927VTropical Aviation LLC · Gulf Shores, ALN8927WFiihr Travis A · Grand Junction, CON8928Anding Jay B · Bryan, TXN8928CGiber Kristofor D · Manvel, TXN8928FDenver Aerospace Science Museum · Watkins, CON8928JHaybron David M · Sewickley, PAN8928MKeyt Jeffrey D · New Providence, NJN8929Cavanagh James B · Litchfield Park, AZN8929JRice Spencer F · Portland, ORN8929LPeters Nicholas J · Eagle River, AKN8929WSimmons Ralph R Jr · Sadler, TXN892ACAri Ben Aviator Inc · Fort Pierce, FL
Back to AD 81-18-04 R2