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.
N6049LExecutive Flight Institute LLC · Murrieta, CAN6049PMurolo Michael · Clancy, MTN6049QBudgett Stephen A · Gilbert, AZN6049ZLockwood Shawn O · Volborg, MTN604AMcmurtrey Loy D · Mountain Grove, MON604ACFlorida Institute Of Technology Inc · Melbourne, FLN604ATBrowning Larry L · Mountain View, CAN604DDParker Tony W · Central, SCN604DGGreysea Air LLC · Algonquin, ILN604EREmbry Riddle Aeronautical University Inc · Prescott, AZN604FFFf22 LLC · Scottsdale, AZN604FLLivingston James L · Harker Heights, TXN604FTFlorida Institute Of Technology · Melbourne, FLN604GCareer Pilot Training LLC · Wilmington, DEN604JAVeracity Aviation LLC · Seguin, TXN604NDHeavy Metal Air LLC · Farmingdale, NYN604RVDayman Patrick Jodey · Nokesville, VAN604TTUniversity Of Alaska Anchorage · Anchorage, AKN604TWChrysalide LLC · Oklahoma City, OKN60501Big Bend Community College · Moses Lake, WAN60503Big Bend Community College · Moses Lake, WAN6050FAmeriflyers Of Texas Inc · Addison, TXN6050LPerry David · Onancock, VAN6050PNeuman Michael R · Valencia, PAN6050WLandoll Aero LLC · O Fallon, ILN6050ZJarman Patrick K · Mount Pleasant, MIN6051GHarvey William W · Spencer, INN6051HFlying Six Inc · Mc Cool Junction, NEN6051LMiller Lyndon · Georgetown, TXN6051QWhite Jeffrey M · Carlsbad, CAN6051RSpalding David · Ketchum, IDN6051VBucelluni Brett · Cypress, TXN6052GErickson Keith E · Anchorage, AKN6052LHoward William R · Newnan, GAN6052NRegistration Pending · Las Vegas, NVRegistration pendingN6052POn Site Aviation Inc · Hillsboro, NDN6052QCash Alan B · Fort Worth, TXN6052ZJackson Paul D · Phoenix, AZN6053DRuddell Brian G · Spokane Valley, WAN6053FAmeriflyers Of Texas Inc · Addison, TXN6053LHenson Randolph C · Spring, TXFirst renewal noticeN6053NErickson Robert · Otis Orchards, WAN6053ZSlack Brenda · Norfolk, VAN6054LTriple-R-Biplane Inc · Andover, NJN6054NPees Philip G · Concord, NCN6054PMartinez Juan R · San Bruno, CAN6055QGlenn Howard Anderson Jr · Wakefield, RIN6055UThomson Mary E · San Francisco, CAN6056CFlight Contract Services Inc · Las Vegas, NVN6056PN6056p LLC · Sonoma, CA
Back to AD 81-18-04 R2