Skip to content

Registered aircraft · 10,639

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-01-05-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:99-01-05-R1') 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-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N86UFWarden Richard L · Canby, ORBuilt 1946 · S/N 121596 N8700DScott Carol P · Fairbanks, AKS/N 22-5880 N8701DHopman Elizabeth Trustee · Quincy, CABuilt 1958 · S/N 22-5882 N8705CMoore Gary W · Newton, KSBuilt 1953 · S/N 22-1363 N8706CMichel Terry L Trustee · Quincy, WAS/N 22-1364 N8706DTolle Chuck G · Deer Creek, OKBuilt 1958 · S/N 22-5887 N8707DOrton Aviation LLC · Walker, MNBuilt 1958 · S/N 22-5888 N8708DAnderson Thomas E Trustee · Mason, OHBuilt 1958 · S/N 22-5889 N8712CCopp Perry T · Adin, CABuilt 1953 · S/N 22-1373 N8712DRegistered aircraftBuilt 1958 · S/N 22-5893 N8714DAzevedo Miguel · Trion, GABuilt 1958 · S/N 22-5895 N8715DKline Linda L · Fountain Hills, AZBuilt 1958 · S/N 22-5896 N8715LScott Ts Ag Flyin Inc · Colquitt, GABuilt 1969 · S/N 25-5168 N8717CBristow Leonard B · Damar, KSBuilt 1953 · S/N 22-1355 N8718CHogan Erin P · Grapevine, TXS/N 22-1357 N8718DSlaughter James M Jr · Houston, TXBuilt 1958 · S/N 22-5899 N871CCUeckert Russell N · Abilene, TXBuilt 2001 · S/N 9933CC N871SCKansas Farm And Ranch Inc · Seneca, KSS/N 18-8935 N8722CMayhew Oliver C Jr · Blairs, VABuilt 1953 · S/N 20-1011 N8722DWirthlin Donald K · Sierra Vista, AZBuilt 1958 · S/N 22-5903 N8723LMid-Georgia Soaring Association Inc · Monroe, GABuilt 1969 · S/N 25-5180 N8724DMoe Daniel N · Mukilteo, WABuilt 1958 · S/N 22-5905 N8725CDavis Byron J · Anchorage, AKBuilt 1953 · S/N 20-1012 N8726CRicco Umberto · Chicago, ILS/N 22-1377 N8726DWheeler Corey L · Lakeport, CABuilt 1958 · S/N 22-5907 N8727DYoung Carl J · Lubbock, TXS/N 22-5908 N8729CQrh LLC · Bartlesville, OKBuilt 1953 · S/N 22-1381 N8729DAdams Raymond L · Big Lake, AKBuilt 1958 · S/N 22-5910 N8730L2 Broke Pilots LLC · Foley, ALBuilt 1969 · S/N 25-5191 N8731DMorrell Eric M · Medford, ORBuilt 1958 · S/N 22-5912 N8732DMgs Ventures Ltd · Wilmington, DEBuilt 1958 · S/N 22-5913 N8734DRains James R · Rockwood, ILBuilt 1958 · S/N 22-5915 N8734LDairyland Aviation Inc · Waupun, WIBuilt 1970 · S/N 25-5197 N8735DLeahy Edward G Trustee · Eldridge, IABuilt 1958 · S/N 22-5916 N8736DWalbert Allin · Grovertown, INBuilt 1958 · S/N 22-5917 N8737DSmith Michael E · Armada, MIBuilt 1958 · S/N 22-5918 N8740CWharton Jerry W · Wise, VABuilt 1953 · S/N 22-1393 N8742LQuality Aviation Inc · Marana, AZBuilt 1970 · S/N 25-5209 N8744COverbeck James M · Pipersville, PABuilt 1953 · S/N 22-1396 N8745YMcnamara Michael G · Anchorage, AKBuilt 1970 · S/N 18-8897 N8746CRiley Shane C · Huntsville, MOBuilt 1953 · S/N 22-1398 N8749DGage Bruce P · Coeur D Alene, IDBuilt 1958 · S/N 22-5932 N874CCValiair Ltd Co Trustee · Casper, WYBuilt 2001 · S/N 9931CC N874SCRichards Ryan J · Boise, IDS/N 18-7409112 N8750LKnutson Wayne R · Tioga, NDBuilt 1972 · S/N 25-5448 N8753CSlayden Steven M · Rhome, TXBuilt 1953 · S/N 18-2836 N8756DExecutive Holdings LLC · Fairbanks, AKS/N 22-5940 N8757CKellermann Denis J · Lompoc, CABuilt 1953 · S/N 18-2844 N8758CYuknis Leonard F · Wasilla, AKBuilt 1953 · S/N 18-2842 N8761CSchlagel Cade P · Dillingham, AKBuilt 1953 · S/N 18-2848

Back to AD 99-01-05 R1