Skip to content

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

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

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.

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

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.

N860AJohnson Plane Services LLC · Greenbrier, TNBuilt 1980 · S/N CE-934 N860CGLeading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N TC-1957 N860TBrashier Gregery A · Decatur, TXBuilt 1964 · S/N D-7715 N861Get Happy Adventures LLC · Leawood, KSBuilt 1965 · S/N G-302 N8610MFawaz Brandon · Etna, CABuilt 1963 · S/N D-7237 N8610QPetersen Mark W · Poplar Grove, ILBuilt 1964 · S/N D-7623 N8611QMiller Mark A · Saint Cloud, FLS/N D-7636 N8612QStockton Ethan · Santa Rosa, CABuilt 1964 · S/N D-7638 N8613MPray Aviation Inc · Augusta, KSBuilt 1963 · S/N TD-546 N8615MBabb Christopher B · Key West, FLFirst renewal noticeBuilt 1963 · S/N D-7239 N861DAirtipp LLC · Tipp City, OHBuilt 1975 · S/N TE-1052 N861DSWilliamson Mark · South Padre Island, TXS/N CE-512 N861RXMullen Robert R III Trustee · Woodland Hills, CABuilt 1979 · S/N E-1449 N861SCSpotted Hawk Aviation LLC · Rosenberg, TXBuilt 1997 · S/N E3128 N861THersman Scott · Ada, MIBuilt 1964 · S/N D-7507 N8620MDoctors Building Inc · Rancho Santa Fe, CABuilt 1963 · S/N D-7289 N8621QGrossman Kenneth Randell · Merced, CABuilt 1964 · S/N D-7645 N8623QS&B Aviation LLC · Incline Village, NVBuilt 1964 · S/N D-7648 N8625MAuto & Bike Shop Inc · Douglas, WYBuilt 1963 · S/N D-7298 N8625QCorona Robert Jr Dr · Bay Shore, NYFirst renewal noticeS/N TC-779 N8626MFlaugher Gerald E · Beloit, WIS/N D-7242 N8627AMckinney Steve R · Hamersville, OHBuilt 1957 · S/N BA-283 N862DRegistered aircraftBuilt 1978 · S/N E-1362 N862KMSiebold Daniel L · Rhinebeck, NYBuilt 1979 · S/N M-2175 N862TNovember 862 Tango Inc · Wilmington, DES/N D-7524 N862WRRomano Walter · Leesburg, VAS/N MC-504 N8630MMerrills Inc · Shreveport, LAS/N TC-497 N8632MMatheny Roger P · Humble, TXBuilt 1963 · S/N D-7245 N8633MFranklin Leonard R · Fresno, TXBuilt 1963 · S/N D-7335 N8636A36a Ltd · Cincinnati, OHBuilt 1982 · S/N E1977 N8636MBassue Jawanza · Savannah, GABuilt 1963 · S/N D-7246 N8636QJv Aviation LLC · Lynden, WABuilt 1964 · S/N D-7658 N8637MScarcella Joseph A · Running Springs, CABuilt 1963 · S/N D-7247 N8637QLindell Michael S · East Wenatchee, WABuilt 1964 · S/N TC-781 N8638MWill Matthew · Duncansville, PABuilt 1963 · S/N D-7249 N8638QJeffery Finis B · Washington, DCBuilt 1964 · S/N TC-784 N8639ARegistration Pending · Sparta, MORegistration pending, pending cancellationBuilt 1949 · S/N D-2049 N8639MCourtney John T · Woodbridge, CTFirst renewal noticeBuilt 1963 · S/N D-7265 N863STesterman George M Md · Kingsport, TNBuilt 1969 · S/N D-8922 N863TWilliams Roger F · Hayward, CABuilt 1964 · S/N TC-739 N8641MCaldwell Glenn A · Garnett, KSBuilt 1963 · S/N TC-529 N8642AKrulic Charlie Bartol III · Greenville, SCBuilt 1949 · S/N D-2052 N8642MRhodes Stephen L · Hayti, MOBuilt 1963 · S/N D-7251 N8643QFirebird Aero LLC · Phoenix, AZBuilt 1964 · S/N D-7660 N8644MShevchuk Walter Bohdan · Kennett Square, PABuilt 1963 · S/N D-7250 N8648MHeinol Chip · Choctaw, OKBuilt 1963 · S/N D-7252 N864SPiekarski John S · Kuna, IDBuilt 1969 · S/N TC-1208 N8650MMcanall Lewis D IV · Severna Park, MDBuilt 1963 · S/N D-7253 N8652AGnb Aviation LLC · Lake City, TNBuilt 1949 · S/N D-2062 N8652RFour Alpha Juliet LLC · Minster, OHBuilt 2000 · S/N E-3354

Back to AD 99-05-13 R1 WD