Skip to content

Registered aircraft · 70

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

N100WBBbcc Foundation · Moses Lake, WABuilt 1966 · S/N LJ-139 N101BSOn Mission Network · Dallas, TXBuilt 1968 · S/N LJ-375 N110ELForsyth Technical Community College · Winston Salem, NCBuilt 1965 · S/N LJ-71 N115PACentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-117 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 N14VDouble D International LLC · Miami, FLS/N LJ-411 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 N198KAThompson Benjamin Kyle · Nevada, TXBuilt 1966 · S/N LJ-162 N2000EBluebird 2000 LLC · Wilmington, DEBuilt 1966 · S/N LJ-172 N22BBSpillman Robert · Port Orange, FLBuilt 1967 · S/N LJ-241 N270MNardi Greg P · Missoula, MTBuilt 1967 · S/N LJ-288 N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132 N292APlacebo Air LLC · Ridgecrest, CABuilt 1966 · S/N LJ-99 N2UVDependable Freight LLC · Bethel, AKBuilt 1969 · S/N LJ-480 N312VFCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-299 N321DZNardi Greg · Missoula, MTBuilt 1968 · S/N LJ-367 N325RRCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-289 N32BAPittsburgh Skydiving Jump Plane LLC · Mercer, PABuilt 1969 · S/N LJ-475 N33SBPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1967 · S/N LJ-252 N394ALTeebird Enterprises LLC · Brighton, COBuilt 1968 · S/N LJ394 N3DFTaurman Keith L · Virginia Beach, VABuilt 1965 · S/N LJ-36 N3XBMonument Aviation LLC · North Chesterfield, VABuilt 1967 · S/N LJ-234 N40BA711bn LLC · Miami, FLBuilt 1969 · S/N LJ-444 N411FTUS Aviation Corp · Miami, FLBuilt 1969 · S/N LJ-443 N416MRJosephine Air LLC · Castle Rock, WABuilt 1967 · S/N LJ-267 N41DZBravo Hotel LLC · Lewes, DEBuilt 1967 · S/N LJ-269 N43JTKolob Canyons Air Services Inc · Wilmington, DEBuilt 1967 · S/N LJ-286 N43MBSky West Aviation Inc Trustee · Albuquerque, NMS/N LJ-463 N43WAWhatever Aviation LLC · Olympia, WABuilt 1970 · S/N LJ-501 N45PRAslesen Leasin LLC · Halstad, MNBuilt 1966 · S/N LJ-145 N469JKQuest Aviation Inc · Lake City, FLBuilt 1967 · S/N LJ-274 N46AXGraber Joel · Collins, MSBuilt 1967 · S/N LJ-317 N479SAEarthcom Inc · Williamston, MIBuilt 1967 · S/N LJ215 N490DMFlying Colors Air Parts Inc · Leesburg, FLS/N LJ468 N4RYCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1964 · S/N LJ-8 N50525Kansas State University · Salina, KSS/N LJ159 N5245FAex Aviation LLC · Davenport, FLBuilt 1965 · S/N LJ-92 N526RRDaytona Hot Cars Inc · Port Orange, FLBuilt 1967 · S/N LJ-263 N579PSFoxtrot Charlie Inc · Grass Valley, CABuilt 1970 · S/N LJ-496 N57AGMonument Aviation LLC · North Chesterfield, VABuilt 1968 · S/N LJ-343 N600BFCentral Virginia Aviation Inc · Petersburg, VABuilt 1966 · S/N LJ-193 N603PACentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-403 N615AASkydive San Joaquin Valley Inc · Bakersfield, CABuilt 1967 · S/N LJ-298 N623BBAirshares Incorp · Petersburg, VABuilt 1967 · S/N LJ-277 N66ADRed Light Skydiving LLC · Jackson, MIBuilt 1968 · S/N LJ-380 N66GSMile Hi Skydivers Inc · Longmont, COS/N LJ-237 N671LLCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N LJ-148 N68CDSkydive Myrtle Beach Inc · Southport, NCBuilt 1968 · S/N LJ-366 N6KZDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N LJ-238

Back to AD 75-08-16