Skip to content

Registered aircraft · 181

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

N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81 N504ECAlpha Tango LLC · Little River, SCBuilt 1995 · S/N BE-120 N519RRCgs 2003 LLC · San Leon, TXBuilt 1978 · S/N BE-40 N51RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-212 N52RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-210 N531CBSpectre Aviation LLC · Dover, DEBuilt 1983 · S/N BE-133 N53RPUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-195 N54USSilver Eagle Express LLC · Orange, CABuilt 1981 · S/N BE122 N55RPUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-198 N5727Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-48 N577DCentral Virginia Aviation Inc · North Dinwiddie, VAS/N B-22 N580SBott Radio Network Inc · Gravois Mills, MOBuilt 1979 · S/N BE-77 N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89 N6045STexoma Building Services LLC · Kingston, OKBuilt 1979 · S/N BE-65 N60TJArk Leasing Inc · Newport Beach, CABuilt 1977 · S/N BE-21 N619DDPark Avenue Group Inc · Stuart, FLBuilt 1980 · S/N BE-92 N627KMSpectre Aviation LLC · Dover, DES/N BE-93 N62989Uas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-183 N63978Uas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-171 N6645KBemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-209 N6724DUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-215 N686ACStm Air LLC · Ocala, FLBuilt 1981 · S/N BE-127 N68MUPark Avenue Group Inc · Stuart, FLBuilt 1978 · S/N BE-37 N68TAUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-177 N699ALBallard Aviation Inc · Newton, KSBuilt 1980 · S/N BE-83 N699CZN699cz LLC · Milwaukee, WIBuilt 1968 · S/N U-10 N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84 N70NPBemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U-14 N711REMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1976 · S/N B-233 N7200ZUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-219 N7207EBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N U-223 N7209WUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-224 N720COscar Charlie LLC · California, MDBuilt 1973 · S/N B-171 N7212PBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N U-220 N747EMSal Holdings LLC · Helena, MTBuilt 1983 · S/N BE-136 N74JVAdvanced Avionics LLC · Cookeville, TNBuilt 1971 · S/N B-74 N770ABAgb Management Inc · Warrenton, VABuilt 1981 · S/N BE121 N770DReynolds Roger David · Key West, FLBuilt 1980 · S/N BE-90 N771CWJ&R Aviation Holdings LLC · Tampa, FLBuilt 1978 · S/N BE-52 N776LDodson International Parts Inc · Rantoul, KSBuilt 1970 · S/N B-54 N77PFAerospace Asset Holdings LLC · Wilmington, DEBuilt 1970 · S/N B-70 N781AKAlsworth Glen Sr · Port Alsworth, AKS/N B-53 N7862RUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-85 N78DARegistered aircraftBuilt 1976 · S/N BE-11 N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68 N799DDRenfro Michael W · Bethel, AKBuilt 1971 · S/N B-102 N802BAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-29 N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55 N81820Uas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N U232 N821CBEz Transportation Inc · Rosharon, TXBuilt 1977 · S/N BE-35

Back to AD 87-03-06 R1