Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N619DCHarvard Air Taxi LLC · Andover, MABuilt 1979 · S/N 34-7970495 N61BBAeronautical Technical Service Inc · Collierville, TNS/N 30-875 N61FHCloud Dancer Aviation Inc · Deland, FLBuilt 1972 · S/N 34-7250255 N61UComanche Skye LLC · Savannah, GABuilt 1966 · S/N 30-1004 N6201JL7 Aviation LLC · Geary, OKBuilt 1976 · S/N 32R-7680331 N6202PCollins Owen Stewart · Toccoa, GAS/N 24-1303 N6203PClark Jason H · Ridgecrest, CABuilt 1959 · S/N 24-1304 N62052Bolinger Ray G · Kuna, IDBuilt 1959 · S/N 24-1235 N6205PTwo Dot Aircraft Ll · Kalispell, MTS/N 24-1307 N6206HBaas Holdings LLC · Lewes, DES/N 34-7870057 N6207NAdvanced Sport Psychology LLC · Orlando, FLBuilt 1980 · S/N 34-8070306 N6207PSquawk 2310 LLC · Ridgefield, WABuilt 1959 · S/N 24-1309 N6208JCranbrook Aviation LLC · Vienna, VABuilt 1976 · S/N 28R-7635321 N6210JFhh Air LLC · New Albany, OHS/N 32R-7680333 N6210PHolbrook Glen A · Marion, WIFirst renewal noticeBuilt 1959 · S/N 24-1312 N6211PPounds Kenneth M · Pueblo West, COBuilt 1959 · S/N 24-1313 N6212PJobin Lyle S · Madeira Beach, FLBuilt 1959 · S/N 24-1314 N6216PDuvall James Grafton III · Silver Springs, NVBuilt 1959 · S/N 24-1318 N6218PSmith Ron E · Goodlettsville, TNBuilt 1959 · S/N 24-1320 N621EDPhantom Aviation LLC · Ormond Beach, FLBuilt 1977 · S/N 34-7770165 N6221JReese Joel Scott · New Smyrna Beach, FLBuilt 1976 · S/N 32R-7680334 N6221PLicata Paul Z · Mexico, MOS/N 24-1323 N6222HMortenson Lyle · Kennebec, SDBuilt 1977 · S/N 28R-7837058 N6222JSafaero Inc · San Clemente, CABuilt 1976 · S/N 32R-7680335 N6222PPacheco Carlos Antonio · Yuma, AZBuilt 1959 · S/N 24-1324 N6222SClear Sky Aviation LLC · Lewis Center, OHBuilt 1973 · S/N 28R-7335197 N6224PDattilio Joseph · Wasilla, AKS/N 24-1326 N6225PMcvey Charles D · Merritt Island, FLBuilt 1959 · S/N 24-1327 N6226PHofstetter Fred M · Boerne, TXBuilt 1959 · S/N 24-1328 N6229JVidosh Brian Jr · Friendswood, TXBuilt 1976 · S/N 32R-7680336 N6229PA2a Aviation Inc · Simsbury, CTBuilt 1959 · S/N 24-1332 N622BRidley Aircraft & Aviation Services LLC · Gilbert, AZBuilt 1966 · S/N 1341 N6230HBrumley Nelson B · Huntsville, TXS/N 34-7870059 N6230JSonnichsen Landen D · Delta Junction, AKBuilt 1976 · S/N 32R-7680337 N6236CAviation Equipment Company LLC · Leesburg, VABuilt 1978 · S/N 28R-7837151 N6236PHill Scott G · Mcdonough, GABuilt 1959 · S/N 24-1341 N6238JDanish Air LLC · Wahpeton, NDBuilt 1976 · S/N 28R-7635324 N6239JBlack Diamond Aviation LLC · Cullman, ALBuilt 1976 · S/N 28R-7635325 N623WJAir Mods And Repair · Robbinsville, NJBuilt 1974 · S/N 28R-7435109 N6240POrtiz Raul D · Fredericksburg, VABuilt 1959 · S/N 24-1345 N6241CK&M Aviation LLC · Kemah, TXBuilt 1978 · S/N 34-7870145 N6244PSimon Projects LLC · Sebastian, FLBuilt 1959 · S/N 24-1349 N6245PBishop Warren · Iowa City, IABuilt 1959 · S/N 24-1351 N6249JAkwari Aerospace LLC · Burbank, CABuilt 1976 · S/N 32R-7680340 N6249PKeller Richard A · Stacy, MNBuilt 1959 · S/N 24-1356 N6251PPearce Donnie D · Mena, ARBuilt 1959 · S/N 24-1358 N6254PMcphee Michael Andrew · Cherokee, TXBuilt 1959 · S/N 24-1361 N6256CKing David M · Plainville, CTBuilt 1978 · S/N 28R-7837154 N6256PReilly Thomas J · Happy Valley, ORBuilt 1959 · S/N 24-1363 N6259PWyant Dustin Jay · Great Bend, KSBuilt 1959 · S/N 24-1366

Back to AD 97-01-01 R1