AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N8119PStelling William F · Fairbury, NEN8119QBay Lux Ventures LLC · Tampa, FLN8119YStar H Aviation LLC · Plano, TXN811ACUnited States Construction Corp · Pompano Beach, FLN811AJScarrow Justin · Palmer, AKN811ASS&A Flying LLC · Minden, NEN811ATDot Aviation LLC · Wilmington, DEN811BJSix Pack Aviation LLC · Pocono Pines, PAN811BLWingsleasing LLC · Wichita, KSN811DHRegistered aircraftN811DWPerucca Douglas E · Wasilla, AKN811EBBanks Cecil E Jr · Dayton, NVN811HATate Grady · Harrisburg, NCN811JDSanders Jason C · Babylon, NYN811LESmith Colin B · San Diego, CAN811LWWeaver Savannah N · Elmore, ALN811PMMcdaniel Erick R · Fort Worth, TXN811RFMapes Neal E · Prineville, ORN811RVMorgan Matthew P · Gainesville, GAFirst renewal noticeN811SEAdams Jonathan O · Columbia, MON811TTJordison Investments LLC · Auburn, WAN811WCampbell 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, MDN8120XMccool Kenneth Wade · Olive Branch, MSN8120YDevries Dennis J · Owasso, OKN8121BVolkmann James P · Bellingham, WAN8121FKraack Stephen T · Lithia, FLN8121JSchluckebier Daniel C · Aldie, VAN8121KRegistered aircraftN81227Grumman Aviation LLC · Virginia Beach, VAN8122BErwin Mark N · Snyder, TXN8122CJordan Walter B · Chehalis, WAN8122HSchlesinger Richard J · West Cornwall, CTN8122LWoodward Thomas M · Granbury, TXN8122QN8122q LLC · Venice, FLN8122WRoberts Barry R · Aurora, CON81237Registration Pending · Austin, TXRegistration pendingN8124GWilliamson Joel B · Goleta, CAN81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeN81251Winfield John F Jr · Scituate, RIN81259Thermodynamic Sciences LLC · Irvington, ALN8125JGreen Rick · Hudson, IAN8125LHillsboro Aero Academy LLC · Hillsboro, OR
Back to AD 90-04-06 R1