AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-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:87-10-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:87-10-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:87-10-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.
N9315PGrady Michael J · Farmington, NMN9315RChase Steven J · Aubrey, TXN9315SBradford Alvin L · Northville, MIN9315VGroff Joseph J · Colfax, CAN9316JStennis Aviation Group LLC · Mandeville, LAN9316MSale Reported · Kalispell, MTSale reportedN9316PProvost Stephen Nicholas · Saint Louis, MON9316VBorghi Robert J · Leonia, NJN9316WPrettyman James M · Sykesville, MDN9317PFutter John H · Whately, MAN9317RLloyd William E Jr · Clinton, TNN9317VSpaghetti Aviation LLC · Derby, KSN9318BAnderson Daniel R · Venus, TXN9318CTarakji Mohamad Hani A · Van Nuys, CAN9318JJohnson Matt · Eugene, ORN9318PPorter Wayne · Phoenix, AZN9319DCloud Buster LLC · Bloomfield, IAN9319HHoffman Stanley L Jr · Bethel, AKN9319JAcs Aviation LLC · Wilmington, DEN9319MCulberson Donald L · Bedford, TXN9319SMeyn Joseph · San Antonio, TXN9319WHunt Dennis Jr · Marlboro, NJN931ASHolland 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, TXN931SAMarc Inc · Bolton, MSN931SHDodson International Parts Inc · Rantoul, KSN931SJTss Flying Club Inc · Bethesda, MDN931ZMason Fred B · Waterford, OHN9320HPlane Tail LLC · Bethany, CTN9320MMoreau Donald G · Dayton, TXN9320NEagle Aviation Inc · Tucson, AZN9320RHaskell Flyers LLC · Sublette, KSN9320WManzo Anthony Michael · Fairmont, WVN9321CBas Part Sales LLC · Greeley, CON9321DNiec Casmier M · Clio, MIFirst renewal noticeN9321JR Goldburg LLC · Gastonia, NCN9321NRegistration Pending · Shreveport, LARegistration pendingN9321PRegistered aircraftN9321WTriplett Joseph C II · Pontotoc, MSN93225Dr Carlton N Walker Dds LLC · Roswell, NM
Back to AD 87-10-06 R1