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.
N711RNGoldsmith Donald E Jr · Brandywine, MDN711RPJwp Flying Services LLC · Chatfield, MNN711RVNicholson Kameran · Fowler, KSN711SGGullo Santo · Ponce Inlet, FLN711SHHighley Robert W Jr · Lakeland, FLN711TANorth Star Equipment LLC · Simms, MTN711TSStarr William E · Eagle River, AKN711UATuthill Andrew M · Etna, NHN711WBNewberg Edgar T · Hector, MNN711WDSeawind Adventures LLC · Reno, NVN711WEMelbourne Flight Training LLC · Melbourne, FLN711XCFore Shannon Richard · Wasilla, AKN711YAStegmann Scott A · Port Orange, FLN711YCIturriria John M · Kuna, IDFirst renewal noticeN711ZHappenstance LLC · Cabot, ARN712Oman Lee · Sequim, WAN7120DWeiss James R · Westlake, OHN7120EFlightgest Academy LLC · Morrisville, NCN7120GSky Hook Inc · Red Wing, MNN7120LTschirhart Larry S · San Antonio, TXN7120QClodfelter Terry Lynn · Norwood, NCN7120VOpulent Investments LLC · Mandan, NDN7120YRoyal Ryan M · Lincoln, NEN7121DBohrman Robert C · New Berlin, WIN7121PLecren Douglas · Wasilla, AKN7121YUhlemeyer William A · Alvin, TXN7121ZQuality Aviation Inc · Marana, AZN7122AContinental Helicopters Inc · Sheffield, TXN7122BCgu Aviation LLC · Naples, FLN7122EChristiansen Aviation LLC · Wilmington, DEN7122GBirmingham Flight Center LLC · Birmingham, ALN7122JCarrizales Chad A · Jacksonville, ARN7122KMacleod Gary G · Valentine, NEN7122RSimmons Heating And Air Conditioning LLC · Summerville, SCN7122VProvance Brent L · Granbury, TXN7122YSutton Jack M · Jesup, GAN7123GJet & Rotor Aviation LLC · Sacramento, CAN7123PMclenaghan Alvain N · Phoenix, AZN7123UMatherly Frank · Greenbrier, TNN7123WHarvick Wayne P II · Kenmore, WAN7124KBlackburn Douglas W · Auke Bay, AKN7124LTriad Management Group LLC · Papillion, NEN7124PTalley John T · Clifton, TXFirst renewal noticeN7124QVy Aviation LLC · Gentry, ARN7124RNewsome Thomas D · Canal Winchester, OHN7124UGoss Brendan · Shady Shores, TXN7124VHunter Cameron Brooks · Keller, TXN7124WTuchols John E · Lockport, NYN7125DWarrior Creek Adventures LLC · Moultrie, GAN7125GBohannan Joshua S · Rose Hill, KSFirst renewal notice
Back to AD 81-18-04 R2