OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N766RCos LLC · Monument, COBuilt 1971 · S/N M-1298N766SQualls Shannon D · Mexico, MOBuilt 1965 · S/N D-7818N766TDecesare George D · Danville, CABuilt 1973 · S/N D-9445N7670RMescher John A · Coldwater, OHBuilt 1970 · S/N MC-58N7671GPremier Aviation LLC · Philadelphia, MSBuilt 1980 · S/N E-1671N7671RBeloiu Matei A · Fort Jones, CABuilt 1969 · S/N M-1268N7673RGiles Dwight L · Greeley, COBuilt 1969 · S/N M-1270N76747Walter Timothy Andrew · San Rafael, CABuilt 1979 · S/N EA-41N7675RKline John C · Wolcottville, INBuilt 1970 · S/N M-1297N7677RAlpha Bravo Charlie 1 Corp · Houston, TXS/N M-1288N7679RSmith Melissa R · Atlanta, ILS/N MA-359N767BHughes Coby D · Collinsville, OKBuilt 1948 · S/N D-1775N767CMValiair Lc Trustee · Casper, WYBuilt 1992 · S/N E2723N767DFMaurin Edward E III · Grand Junction, COBuilt 1988 · S/N E-2403N767FAQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N TE1188N767JCCole Jeffrey E · Rockwall, TXS/N E-797N767MRSpn Construction Inc · Brownsville, TXS/N P-531N767PCIrbf Corporation · Wilmington, DEBuilt 1970 · S/N TE-770N767TMJavelina Aero LLC · Sheridan, WYBuilt 1967 · S/N D-8556N767URegistered aircraftBuilt 1968 · S/N D-8873N7680NTpc Air LLC · Colleyville, TXBuilt 1968 · S/N TC-1154N7680RPotter Steven R · Grapevine, TXS/N MB-502N7682RTrull Stephen G · Golden Valley, MNBuilt 1969 · S/N MB-452N7684NMccarthy Mitchell S · Stamford, CTBuilt 1968 · S/N D-8867N7687RTaylor Edward P Jr · Spanishburg, WVBuilt 1970 · S/N M-1308N7688RTrudeau Lemaster Productions · Woodland Hills, CABuilt 1969 · S/N MC-2N7689RDelehant Edward J III · Keller, TXBuilt 1970 · S/N M-1289N768KMShafferman Edward L · Shreveport, LABuilt 1963 · S/N D-7256N768WMcwilliams Russell · Flower Mound, TXBuilt 1977 · S/N TC-2108N7691RWestfall Brent J · Three Lakes, WIBuilt 1970 · S/N MB-487N7693RErickson Kenneth W · Mill Creek, WABuilt 1970 · S/N M-1293N76940Gsh Of Alabama LLC · Huntsville, ALS/N D-8861N7694NBradley Dennis M · Newburgh, MEBuilt 1968 · S/N D-8869N7694RC23 LLC · Pendleton, ORS/N M-1294N7695NChalk 2 Inc · Apple Valley, CABuilt 1968 · S/N D-8870N7696RRice John · Dothan, ALS/N M-1296N769ACAircraft Propulsion Leasing LLC · Holland, OHBuilt 1978 · S/N TK-89N769RJWings South Inc · Fayetteville, GABuilt 1963 · S/N TC-536N769TPatterson David Roy · Lockney, TXBuilt 1972 · S/N D-9395N769XXBallard Aviation Inc · Newton, KSBuilt 1980 · S/N CE-885N76ADynamic Avlease Inc · Bridgewater, VABuilt 1957 · S/N BA-262N76ACTennessee Aviation Company LLC · Knoxville, TNBuilt 1980 · S/N E-1791N76BAWestphal Jon A · Menomonie, WIBuilt 1975 · S/N E-783N76BBEdl Sf Enterprise LLC · Coral Springs, FLBuilt 1952 · S/N D-3110N76DBAek Property 6 LLC · Glendale, AZBuilt 1975 · S/N CE-608N76DUL&P Of Mke LLC · Milwaukee, WIBuilt 1978 · S/N ME-52N76JMayer Kevin D · Lima, OHBuilt 1958 · S/N D-5616N76KULaurent Michael · Queen Creek, AZS/N D-7319N76KWTriple Bee Transport LLC · Leon, WVBuilt 1980 · S/N TC-2318N76LThacker Flying Club LLC · Griffin, GAS/N DH-183
Back to AD 99-05-13 R1 WD