Skip to content

Registered aircraft · 17,027

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

N52831Truck Guy Inc · Coweta, OKS/N 177RG1282 N52838Benham Aviation LLC · Enid, OKBuilt 1977 · S/N 177RG1284 N52839Cardinal Flyers LLC · Farmington, MOBuilt 1977 · S/N 177RG1285 N5284UCochrane Timothy A · Chippewa Lake, OHBuilt 1964 · S/N U206-0284 N52851Mcnamee Brian E · Pompano Beach, FLBuilt 1977 · S/N 177RG1287 N5285QBartell Kevin W · Abbottstown, PABuilt 1972 · S/N 15073185 N5285UShroyer Jayme D · Longmont, COBuilt 1964 · S/N U206-0285 N52862Klosterman Sean M · Seattle, WABuilt 1977 · S/N 177RG1290 N5286QPasterski Mark F · Chicago, ILBuilt 1972 · S/N 15073186 N52871North Cardinal LLC · Crookston, MNBuilt 1977 · S/N 177RG1294 N52878Martin Carver Jessica · Bowling Green, KYS/N 177RG1297 N5287QRice James L · Mckinney, TXBuilt 1972 · S/N 15073187 N52881Cardinal Air · Gold Hill, NCBuilt 1977 · S/N 177RG1298 N52882Qdp Inc · Cincinnati, OHBuilt 1977 · S/N 177RG1299 N52885Foster David F · Potomac, MDBuilt 1977 · S/N 177RG1300 N5288QErnie Hall Aviation Museum Inc · Warren, OHS/N 15073188 N52890Schlafly Sheila B · Miami, FLBuilt 1977 · S/N 177RG1301 N52894Craren Michael J · Holliston, MABuilt 1977 · S/N 177RG1302 N5289QNielson Douglas W · East Troy, WIBuilt 1972 · S/N 15073189 N52908Ichinose Ryan · Fort Worth, TXBuilt 1977 · S/N 177RG1306 N5290QSaso Jan D · Hughson, CABuilt 1972 · S/N 15073190 N5291QQuinn Robert J · Kelleys Island, OHBuilt 1972 · S/N 15073191 N52930Sir Grantham Of Kloofbear Inc · Wilmington, DEBuilt 1977 · S/N 177RG1312 N52936Reimer Dean R · Yuma, AZBuilt 1978 · S/N 177RG1313 N5293QRoberts Jeffrey E · Wheeling, WVBuilt 1972 · S/N 15073193 N52944Masiero Christophe D · Winter Garden, FLBuilt 1978 · S/N 177RG1315 N52946Pluntze Stephen C · El Segundo, CABuilt 1977 · S/N 177RG1317 N5296QSun Baron · Arcadia, CABuilt 1972 · S/N 15073196 N5296UMeyers Karl F · Tucson, AZRegistration revokedBuilt 1964 · S/N U206-0296 N5297QFalmouth Aviation LLC · North Falmouth, MABuilt 1972 · S/N 15073197 N52987Lewis Nathan A Trustee · Watsonville, CABuilt 1978 · S/N 177RG1323 N5298QKirsch Richard D · Lisbon, NDBuilt 1972 · S/N 15073198 N5298UPatanapong Somboonsap · Oakland Park, FLBuilt 1964 · S/N U2060298 N52990Hurley Drew M · Port Orange, FLBuilt 1978 · S/N 177RG1324 N5299QJa Flight Services LLC · Sugar Grove, ILBuilt 1972 · S/N 15073199 N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741 N52BJTca LLC · Fountain Hills, AZBuilt 1977 · S/N 177RG1183 N52CRCairns Douglas S · Bozeman, MTBuilt 1968 · S/N 18259237 N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506 N52HPHeritage Aviation Management LLC · Headland, ALBuilt 1967 · S/N R1720079 N52KKVon Sternbert Nicholas Josef · Valencia, CAS/N 17700563 N5300QHopson Larry K · Conroe, TXS/N 15073200 N53026Oehl Robert · Jacksonville, FLBuilt 1978 · S/N 177RG1327 N53029N53029 Cardinal LLC · Rosharon, TXBuilt 1978 · S/N 177RG1328 N5302RTrinque Robert L Trustee · Plymouth, MABuilt 1965 · S/N 17252823 N53035International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 177RG1329 N53036Aviation Gt Inc · Wilmington, DEBuilt 1978 · S/N 177RG1330 N5303QWest Prairie Aircraft LLC · Weiner, ARBuilt 1972 · S/N 15073203 N5304RSouthern Arkansas Univ Tech · Camden, ARFirst renewal noticeBuilt 1965 · S/N 17252826 N53053Taylor Jesse L · Venus, FLBuilt 1978 · S/N 177RG1332

Back to AD 72-03-03 R3