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.
N9529SRegistered aircraftN9529WFlight Operations Aircraft LLC · Wilmington, DEN952AArcher Aero LLC · Wilmington, DEN952DAEppes Michael Scott · Austin, TXN952EROliver Lawrence G · Lewiston, MEN952GSStiffler Gary C · Goshen, OHN952JAHuerta Holdings Inc · Santa Ana, CAN952JCCarver Jonathan E · Oxford, NCN952LCThorx Aviation LLC · Tampa, FLN952MKhan Mohsin H · Lodi, CAN952NDUniversity Of North Dakota · Grand Forks, NDN952SCMike Charlie Aviation LLC · Scottsdale, AZN952SHNelson Chris · Crown Point, INN952SMBarnes Kingsley · Springfield, MON952TBLong Jacob · Bend, ORN952TFAir Fleet Holdings LLC · Missoula, MTN952WAMcenery William J · East Haddam, CTN95302Wright David W · Arlington, TXN95303Morrison Robert F II · Denton, TXN95305Eagle Aviation Inc · Tucson, AZFirst renewal noticeN9530BSierra Alpha Aeronautical LLC · San Antonio, TXN9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VAN9530JNations Jeffrey L · Kingshill, VIN9530LClark Dale H · Discovery Bay, CAN9530URegistered aircraftN9530WGateway Flight Training LLC · Saint Louis, MON95314Menagerie Enterprises Inc · Denison, TXN95315Valencic Adam · Apopka, FLN9531DAtp Aircraft 4 LLC · Wilmington, DEN9531JGrayhawk Flight Training LLC · Lucas, TXN9531KCline Timothy E · Rome, GAN9531LBaker Bob E · Carmichael, CAN9531MWright Bradley S · Quitaque, TXN9531UClarke Adam M · Lompoc, CAN95327Seashell Aviation LLC · Milton, FLN95329Jay Stylz Trucking LLC · Cedar Rapids, IAN9532DPayne Frederick B · Fayetteville, GAN9532JHarris Jason L · Clanton, ALFirst renewal noticeN9532LShattuck Charles W · Goshen, CTN9532PAerial Banners North Inc · Pembroke Pines, FLN9532URosenkranz James H · Garland, TXN9532WRodriguez Santos Jr · West Plains, MON9533GSmith James R · Delaware, NJN9533JWadel Ronald A · Shippensburg, PAN9533MHattensty Robert Wade · Burleson, TXN95343Obert Megan E · Hartselle, ALN95346Jackson Douglas A · Cynthiana, KYN95347Jora Imports LLC · Atlanta, GAN9534DLevinson Isaac F · White Salmon, WAN9534HBotezatu Florin · Gig Harbor, WA
Back to AD 81-18-04 R2