Skip to content

Registered aircraft · 827

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-23-07') 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-23-07') 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-23-07')
    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-23-07')
  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-23-07')
  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-23-07')
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.

N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1314GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1154 N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514 N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701 N1322GSmetters Jeffrey L · Crystal Lake, ILBuilt 1974 · S/N 310Q1160 N1338GWings Air Charter LLC · Wisconsin Rapids, WIBuilt 1974 · S/N 310R0022 N1339GLyon Aviation Inc · Pittsfield, MABuilt 1974 · S/N 310R0023 N133CWDeniro Corp · Hampton, NHBuilt 1978 · S/N 310R1260 N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026 N1346GClear Blue Aviation LLC · Melbourne, FLBuilt 1974 · S/N 310R0029 N1349GWings Of Grace Ministries Inc · Melbourne, FLBuilt 1976 · S/N 310R0706 N1351G310 LLC · Conover, NCBuilt 1976 · S/N 310R0708 N1359GEaglehead Aviation LLC · Tifton, GABuilt 1976 · S/N 310R0714 N1371GFall Gregory F · Hanson, MABuilt 1976 · S/N 310R0725 N137DMiller Aviation LLC DBA · Huntington, INBuilt 1981 · S/N 310R2136 N13PKOaks Aviation LLC · Clear Lake, MNBuilt 1981 · S/N 310R2127 N140RBKessler Nicholas · Central Point, ORBuilt 1979 · S/N 310R1807 N141DEEssex Lisa · Oceanside, CABuilt 1973 · S/N 310Q-0805 N1420NKlomhaus Paul · Poplar, WIBuilt 1978 · S/N 310R1398 N142CTMiddleton Charles H · Hamilton, INFirst renewal noticeBuilt 1976 · S/N 310R0629 N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N150BGMbw Aviation LLC · Bay City, MIS/N 310R-0635 N1549TPalmer Jonathan L · The Woodlands, TXBuilt 1973 · S/N 310Q0755 N1565TForbes Consolidated Inc · New Smyrna Beach, FLBuilt 1974 · S/N 310R0063 N1581GKovach Kenneth R · Jefferson, OHBuilt 1979 · S/N 310R1593 N15JDSwanson Alec · Hanahan, SCBuilt 1972 · S/N 310Q0476 N15TVDfl Management Corp · New Castle, DES/N 310R0945 N15WRAcmc Operations LLC · Cedar Park, TXBuilt 1975 · S/N 310R0553 N168EDTsg Aviation LLC · Wyandotte, MIBuilt 1975 · S/N 310R0134 N169DKStanton James · North Barrington, ILBuilt 1978 · S/N 310R1412 N16EZAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1978 · S/N 310R1277 N1716EMccaskill William L · Hampton, VABuilt 1978 · S/N 310R1547 N1718ECaptain Kenny J LLC · Holiday, FLBuilt 1978 · S/N 310R1548 N1735ERsc Ventures LLC · Phoenix, AZBuilt 1978 · S/N 310R1555 N1737EKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1556 N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558 N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566 N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710 N1781ECallaham John · Broken Bow, OKBuilt 1979 · S/N 310R1571 N1784EHigh Road Time LLC · West Palm Beach, FLBuilt 1979 · S/N 310R1574 N1791ESol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1576 N1795ERb Aviation LLC · Tyler, TXBuilt 1979 · S/N 310R1577 N1796GHorowitch Alan · San Diego, CABuilt 1975 · S/N 310R0048 N17GWSalus Aviation LLC · Jupiter, FLBuilt 1975 · S/N 310R0555 N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581

Back to AD 75-23-07