Skip to content

Registered aircraft · 930

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

N7399ETenney Curtis J · Sevierville, TNBuilt 1960 · S/N 57099 N7401ECosta Air Service LLC · Painted Post, NYBuilt 1959 · S/N 57101 N7409EDavis Julius E · Theodore, ALS/N 57109 N740BBellas Business LLC · Kalispell, MTS/N 57282 N7410EFerguson Thomas H · Springfield, MOBuilt 1960 · S/N 57110 N7411ERenshaw Elliott · Lavernia, TXBuilt 1960 · S/N 57111 N7412ELorraine Aviation LLC · Lewes, DEBuilt 1960 · S/N 57112 N7425EYoung James Steele · San Diego, CABuilt 1960 · S/N 57125 N7430EBallesteros Irlena · Glendale, CAS/N 57130 N7431EGeyer Austin D · Minot, NDS/N 57131 N7436EFreedom Airforce · Albuquerque, NMBuilt 1960 · S/N 57136 N7438EWalker Jim O · Lovell, WYBuilt 1960 · S/N 57138 N7440EWilson Colton M · Wellsville, UTS/N 57140 N7445EElite Aircraft Sales LLC · Searcy, ARS/N 57145 N7449EDabir-Ebrahimi Mike M · San Mateo, CABuilt 1960 · S/N 57149 N7450EFernald Greg · New River, AZBuilt 1960 · S/N 57150 N7451ETucker Charles M · White City, ORBuilt 1960 · S/N 57151 N7453EMuller Ronald V · Kansas City, MOBuilt 1960 · S/N 57153 N7467EWirfel James K · Shingle Springs, CABuilt 1960 · S/N 57167 N7477EBravo 70 LLC · West Bloomfield, MIS/N 57177 N7483EMerriman David A · Rocklin, CABuilt 1960 · S/N 57183 N7485EJacques Steve C · Centennial, COBuilt 1960 · S/N 57185 N7491EBenscoter Richard S · Nordman, IDBuilt 1960 · S/N 57191 N7497EDunford David R · Maryville, TNBuilt 1960 · S/N 57197 N75YAHayes David M · Edgewood, TXBuilt 1965 · S/N 21058665 N763TCN42 Hy LLC · Kalispell, MTBuilt 1966 · S/N T210-0113 N76RRReynolds Joseph I · Irving, NYBuilt 1959 · S/N 57051 N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357 N7743GVaughn Investment Services LLC · New Plymouth, IDS/N 57046 N777GTShillings Phillip J · Goldthwaite, TXS/N 21058339 N777JKGeoterra Inc · Eugene, ORS/N 21064714 N77ESRegistered aircraftBuilt 1964 · S/N 21058256 N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104 N78FWoods Joseph Lee · Gilbert, AZBuilt 1963 · S/N 21058258 N799PCRegistration Pending · Colorado Springs, CORegistration pendingBuilt 1966 · S/N T210-0178 N79THHudson Thomas · Bessemer, ALBuilt 1964 · S/N 21058329 N7RDSchipper Properties Inc · San Jose, CABuilt 1967 · S/N 21058847 N811XArkoma Aviation LLC · Henryetta, OKBuilt 1966 · S/N T210-0068 N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330 N87MSCrist Lawrence E · Marietta, GAS/N 210-61588 N8844GNorthside Logistics And Automotive Inc · Dardanelle, ARS/N 21059144 N8LVBeau Dette Corp · Bloomfield, NEBuilt 1960 · S/N 21057691 N8NURbc Aviation LLC · Hollywood, FLBuilt 1966 · S/N T210-0220 N905BWMauro William J · Lancaster, CABuilt 1968 · S/N 21059033 N906RSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 21058625 N911MCKing Daddy Aviation LLC · Madison, MSS/N 21057773 N919RRodriguez Daniel L · West Linn, ORS/N 21059032 N930LFWanner Robin L · Lufkin, TXBuilt 1966 · S/N 21058766 N9400XWilliams Dutch R · Mohave Valley, AZBuilt 1961 · S/N 21057700 N9402XSewell John · Sugar Grove, ILBuilt 1961 · S/N 21057702

Back to AD 76-14-07 R2