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.
N811GSTri-Delta Design LLC · Cedar Park, TXN811GWGreat Western Aviation Leasing LLC · Ogden, UTN811HATate Grady · Harrisburg, NCN811JBGaskin Aviation LLC · Tallahassee, FLN811JDSanders Jason C · Babylon, NYN811KBChristensen Robert E Trustee · Wasilla, AKN811KSFargo Jet Center LLC · Fargo, NDN811LESmith Colin B · San Diego, CAN811LWWeaver Savannah N · Elmore, ALN811PMMcdaniel Erick R · Fort Worth, TXN811RFMapes Neal E · Prineville, ORN811RVMorgan Matthew P · Gainesville, GAFirst renewal noticeN811SSmith Helicopters Inc · Cotulla, TXN811SEAdams Jonathan O · Columbia, MON811TTJordison Investments LLC · Auburn, WAN811TWNova Aircraft Holdings Inc · San Diego, CAN811VClayton Camden Logan · Pensacola, FLN811WCampbell Larry L · Fort Mill, SCN811WJNear William J · Weirsdale, FLN811YDRiser Aviation LLC · Foley, ALN811ZRhoads Timothy C · Logan, NMN81202Pray Aviation Inc · Augusta, KSN8120BGreat Northern Aircraft Inc · Griffith, INN8120FPray Aviation Inc · Augusta, KSN8120JCope Christopher J · Plumas Lake, CAN8120MMckissick John R · Westminster, MDN8120PLysford Troy D · Dalhart, TXN8120XMccool Kenneth Wade · Olive Branch, MSN8120YDevries Dennis J · Owasso, OKN8121BVolkmann James P · Bellingham, WAN8121FKraack Stephen T · Lithia, FLN8121JSchluckebier Daniel C · Aldie, VAN8121KRegistered aircraftN81223Eat Aviation LLC · Metter, GAN81227Grumman Aviation LLC · Virginia Beach, VAN8122BErwin Mark N · Snyder, TXN8122CJordan Walter B · Chehalis, WAN8122HSchlesinger Richard J · West Cornwall, CTN8122LWoodward Thomas M · Granbury, TXN8122PDamico Anthony J · Riverview, FLN8122QN8122q LLC · Venice, FLN8122WRoberts Barry R · Aurora, CON8122ZCrosswinds Flying Club Inc · Bloomington, ILN81237Registration Pending · Austin, TXRegistration pendingN8123CTurlock Fruit Company Inc · Turlock, CAN8123WHoke Todd D · Hilton Head Island, SCN8124ADakota 7 LLC · Kirkwood, MON8124GWilliamson Joel B · Goleta, CAN8124JBulluck Martha C · Apex, NCN8124MSale Reported · Hollister, CASale reported
Back to AD 81-18-04 R2