Skip to content

Registered aircraft · 65

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-09-01') 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-09-01') 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-09-01')
    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-09-01')
  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-09-01')
  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-09-01')
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.

N103BABemidji Aviation Services Inc · Bemidji, MNBuilt 1971 · S/N LD-435 N103MPJoyce George E · Franklinville, NCS/N LF-50 N104BABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-235 N106BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N LD-409 N110BABemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-279 N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297 N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331 N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202 N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68 N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71 N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68 N188Gear Robert Lee III · Paradise Valley, AZS/N LC70 N197CANighthawk Air Systems Inc · Miami, FLBuilt 1965 · S/N LD-246 N2038WYanagida Kazuaki · Norco, CABuilt 1973 · S/N LD-459 N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34 N218PDMoye Robert W · Saint Augustine, FLS/N LF-48 N263CNorpoth Robert L · Circleville, OHS/N LB28 N2700R-Plane Inc · Wilmington, DEBuilt 1979 · S/N 465-7 N306DBemidji Aviation Services Inc · Bemidji, MNS/N LD-439 N41HWFresh Air Aviation Inc · Charlevoix, MIS/N LF73 N441MCBemidji Aviation Services Inc · Bemidji, MNS/N LF 45 N442MCMerrell Jon P · Wolcott, NYS/N LF 54 N44MAPacific Mission Aviation · Hagatna, GUS/N LD-412 N465NQueen Air Aviation Inc · Belleview, FLBuilt 1967 · S/N LC-255 N46MAPacific Mission Aviation · YapBuilt 1969 · S/N LD-413 N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87 N4RANyerges James · Midland, TXBuilt 1969 · S/N LB-4 N5078EBemidji Aviation Services Inc · Bemidji, MNBuilt 1963 · S/N LF-76 N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8 N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16 N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32 N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52 N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35 N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27 N5080LBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-59 N51685Midland Avionics LLC · Louisville, KYS/N LC-40 N527QSilver Linings Air And Farm LLC · Chamblee, GABuilt 1968 · S/N LC-284 N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191 N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243 N60FXAmeriflight Management Services Inc · Orlando, FLBuilt 1968 · S/N LC-312 N60NKKirchhoefer John D · Orlando, FLBuilt 1969 · S/N LC-328 N648DCSomerset Regional Water Resources · Friedens, PAS/N LD-351 N6558Metropolitan Airport Authority · Moline, ILS/N 85 N659Gulf South America Air Transport Inc · Mobile, ALS/N LC72 N65CSChallans Robert F · Hesston, KSS/N LC-82 N65QAGulf States Air Inc · Bossier City, LAS/N LC-165 N66GMEdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LB-1 N6890QSoest Dean · Quartz Hill, CABuilt 1965 · S/N LD-224 N6AQNyerges James · Midland, TXBuilt 1964 · S/N LD-214 N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49

Back to AD 76-09-01