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.
N9319HHoffman Stanley L Jr · Bethel, AKN9319JAcs Aviation LLC · Wilmington, DEN9319MCulberson Donald L · Bedford, TXN9319SMeyn Joseph · San Antonio, TXN9319WHunt Dennis Jr · Marlboro, NJN931APAustin Peay State University · Clarksville, TNN931ASHolland William W · Bainbridge, INN931CELinke John H · Norfolk, NEN931ECRegistration Pending · Panama City, FLRegistration pendingN931GArcher Flight LLC · Wilmington, DEN931JBPyxis Volare LLC · Winter Garden, FLN931LTAerosim Flight Academy · Sanford, FLN931MBusciglio Daren A · Tampa, FLN931MSColeman Aviation LLC · Livingston, TNN931PKBewley Corey T · Midlothian, TXN931QACullman Rotorcraft Inc · Vinemont, ALN931RGScates Gregory B · Melba, IDN931RKFratt John R · Cleveland, TXN931SCActiveair LLC · Erie, PAN931SHDodson International Parts Inc · Rantoul, KSN931SJTss Flying Club Inc · Bethesda, MDN931ZMason Fred B · Waterford, OHN9320HPlane Tail LLC · Bethany, CTN9320LColton Casey Daniel · Lutz, FLN9320MMoreau Donald G · Dayton, TXN9320NEagle Aviation Inc · Tucson, AZN9320RHaskell Flyers LLC · Sublette, KSN9320WManzo Anthony Michael · Fairmont, WVN93214Sundance Air Services Inc · Alameda, CAN9321CBas Part Sales LLC · Greeley, CON9321DNiec Casmier M · Clio, MIFirst renewal noticeN9321JR Goldburg LLC · Gastonia, NCN9321NRegistration Pending · Shreveport, LARegistration pendingN9321WTriplett Joseph C II · Pontotoc, MSN93225Dr Carlton N Walker Dds LLC · Roswell, NMN9322DHitchcock Mark J · Scottsdale, AZN9322JZollitsch Allan P · Lancaster, NYN9322MQuebedeaux Rentals LLC · Deridder, LAN9322RNickname LLC · Scappoose, ORN9322SBrungard Thomas L · Walnut Creek, CAN93239Minuteman Aviation Inc · Missoula, MTN9323ASale Reported · Tumwater, WASale reported, pending cancellationN9323ESchock Richard F II · Peoria, ILN9323FCouch Bill A · Palestine, TXN9323JDaissaoui Anouar · Quincy, MAN9323MMichael Siewert · Columbus, OHN9323VRoll Douglas J · Bradenton, FLN9324DRegistered aircraftN9324JAdbdelsalam Moustafa · Buena Park, CAN9324KBellew Philip H · Gadsden, AL
Back to AD 81-18-04 R2