Skip to content

Registered aircraft · 50

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:89-25-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-25-08') 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:89-25-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-25-08')
  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:89-25-08')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-25-08')
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 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 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 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 N46MAPacific Mission Aviation · YapBuilt 1969 · S/N LD-413 N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87 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 N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191 N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243 N648DCSomerset Regional Water Resources · Friedens, PAS/N LD-351 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 N6890QSoest Dean · Quartz Hill, CABuilt 1965 · S/N LD-224 N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49 N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360 N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391 N7817LNyerges James · Midland, TXBuilt 1967 · S/N LD-340 N800EQMccauley Kerry D · Menomonie, WIBuilt 1960 · S/N LF-24 N800QACitadelle Holdings LLC · Palmetto Bay, FLBuilt 1962 · S/N LD-29 N80RRBemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-296 N810ADGulf States Air Inc · Bossier City, LAS/N LD-328 N840STransnational Aviation LLC · Arlington, TXBuilt 1962 · S/N LF-38 N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42 N911PYOrchtrans Inc Trustee · Wilmington, DEBuilt 1960 · S/N LF-21 N9546QNasair Aviation Services LLC · West Long Branch, NJBuilt 1966 · S/N LC-231

Back to AD 89-25-08