Skip to content

Registered aircraft · 162

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:68-14-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-14-01') 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:68-14-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-14-01')
  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:68-14-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-14-01')
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.

N100FMRivkin Gerald · Saint Augustine, FLBuilt 1969 · S/N TE-729 N100NKLand Air Sea Inc · Chesapeake, VABuilt 1969 · S/N TE-767 N10AKCygnus Holdings LLC · Ballwin, MOBuilt 1969 · S/N TE-765 N1110AMoore John C DBA · San Miguel, CABuilt 1969 · S/N TG-80 N11FFJet Speed Aviation Inc · Las Vegas, NVS/N TE-736 N12BUVan Liew Bradford · Johns Island, SCBuilt 1968 · S/N TE-595 N134CBGlobal Coin Logistics LLC · Lexington, KYBuilt 1967 · S/N TG-40 N13MKLjh Consulting Services LLC · Greenleaf, IDBuilt 1968 · S/N TE-515 N155LUnderwood Robert · Waxahachie, TXBuilt 1968 · S/N TE-467 N155LCAle & Quail Club LLC · Cheyenne, WYBuilt 1968 · S/N TE-615 N18MDN18md Aviation LLC · Salem, ORBuilt 1967 · S/N TE-455 N1968DBellamy Inc · Three Forks, MTBuilt 1968 · S/N TE-576 N200SPN200sp LLC · Erie, COBuilt 1967 · S/N TE-487 N211EBGarrard Mark E · Reno, NVBuilt 1968 · S/N TE-656 N212GWTim D Wilson Investigations Inc · Hempstead, TXS/N TE-494 N221HRRota Aviation Consulting LLC · Sutton, AKBuilt 1967 · S/N TG-48 N222ASBenham Properties LLC · Sullivan, INBuilt 1968 · S/N TE-526 N2296VGustafson Kim L · Lake Stevens, WABuilt 1968 · S/N TE-587 N234TPBoyes Robert L · Benton City, MOS/N TG-71 N241NPNauti Plane LLC · Wilton Manors, FLBuilt 1968 · S/N TE-648 N256TCHyder Racing LLC · Kalispell, MTBuilt 1967 · S/N TG-39 N25JKCoastal Slr Corperation · Port Orange, FLBuilt 1968 · S/N TE-533 N276DDuval Randall Lynn · Mckinney, TXBuilt 1967 · S/N TG-5 N27VMBlue Star Aviation LLC · Saint Augustine, FLBuilt 1969 · S/N TE-698 N281STucker Daniel · Weatherford, TXBuilt 1968 · S/N TE-566 N291TPlane Fun Inc Tr Trustee · Snellville, GAS/N TG-13 N2DQLemont Corp · Southwest, PABuilt 1967 · S/N TG-3 N300JRBeechcraft Heritage Museum · Tullahoma, TNBuilt 1968 · S/N TG70 N300MSChua Johann L · Daly City, CABuilt 1969 · S/N TE-688 N3086CBlue Baron Fl LLC · Saint Cloud, FLS/N TE-510 N321NOatman Scott A · Colorado Springs, COBuilt 1968 · S/N TE-583 N321RR321 Rr Lp · Wimberley, TXBuilt 1968 · S/N TE-520 N3221RBoyes Robert L · Benton City, MOBuilt 1967 · S/N TG-27 N322SPBurkett Gary L Trustee · Murfreesboro, TNBuilt 1968 · S/N TE-531 N323JLLeghorn Airfleet LLC · Columbus, INBuilt 1968 · S/N TE-608 N361SCShelton Jaime David · Hurricane, UTBuilt 1969 · S/N TE-696 N369BBRandigo LLC · Wilmington, DEBuilt 1967 · S/N TD-713 N373LMAdkisson William C · Conway, ARBuilt 1969 · S/N TE-740 N377WBradley Aviation LLC · Whiteland, INS/N TE-683 N381SBettys Beech LLC · Conway, ARBuilt 1968 · S/N TE-629 N394MCRegistered aircraftBuilt 1969 · S/N TE-755 N41258Ricks Brothers Aviation LLC · Greenwood, MSBuilt 1967 · S/N TG-25 N415RWSale Reported · Jasper, ALSale reportedBuilt 1968 · S/N TE-643 N420SFunchess Thomas A · Hazlehurst, MSBuilt 1969 · S/N TG-74 N433KHuffine Kenneth A · Caswell Beach, NCBuilt 1968 · S/N TE-564 N434RSWestfall Brent J · Three Lakes, WIBuilt 1968 · S/N TE-582 N43DBMuller Michael C · Peachtree City, GABuilt 1968 · S/N TE-617 N44MPMiller Dennis Joseph · Bartlett, TNBuilt 1969 · S/N TE-760 N44NKNist Joseph Anthony II · Pittsburgh, PABuilt 1968 · S/N TE-470 N455FPRobert Corio Inc · Johnston, RIS/N TE-549

Back to AD 68-14-01