Registered aircraft · 250

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-16-02-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-16-02-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-16-02-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-16-02-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-16-02-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-16-02-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.

N223CMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA223 N2292KB & K Leasing Inc · Nantucket, MABuilt 1951 · S/N CA-8 N22BRDakota Express LLC · Wilmington, DEBuilt 1965 · S/N BA-729 N231LJBlackhawk Aircraft Maintenance Inc · Janesville, WIBuilt 1945 · S/N 23835 N2382BReed Hollow Aviation LLC · Franktown, COBuilt 1950 · S/N CA261 N23BRDakota Express LLC · Wilmington, DES/N BA-159 N241DBarron Aviation LLC · Perry, MOBuilt 1961 · S/N AF-850 N245MDawson Jamie Stewart · Celina, TXBuilt 1963 · S/N BA-646 N24YHoge Aviation LLC · Pipersville, PAS/N BA-301 N251KNeenah Classic Aircraft LLC · Neenah, WIBuilt 1956 · S/N BA-170 N26035Aom Aircraft LLC · Wilmington, DES/N BA-754 N2625Aero Specialists Inc · Eloy, AZBuilt 1952 · S/N AF-601 N26PLTwin Beech LLC · Kalispell, MTBuilt 1964 · S/N BA-679 N279SCGrieff John J · Punta Gorda, FLBuilt 1955 · S/N BA-74 N2833GVintage Aero Inc · Brandon, FLBuilt 1951 · S/N AF-159 N2913BW Air Collection Inc Trustee · Wilmington, DEBuilt 1953 · S/N A-963 N29BAMax Q Aviation LLC · Kalispell, MTS/N BA-625 N2APNipper Samuel M · Hampton, GABuilt 1954 · S/N 48-9493 N307BLarson Kyle · Trenton, SCBuilt 1959 · S/N BA-457 N30GAg Air Inc · Matthews, MOBuilt 1946 · S/N A-131 N30GBMission Air Aviation LLC · Roanoke, VABuilt 1964 · S/N BA-688 N310GBMission Air Aviation LLC · Roanoke, VABuilt 1954 · S/N AF-856 N3111Setter Thomas D · Burnsville, MNBuilt 1953 · S/N A-964 N3127BFederal Aerial Applicators LLC · Wilmington, DEBuilt 1952 · S/N CA-253 N317MHWalton Cheryl H · Indianapolis, INBuilt 1959 · S/N BA-440 N320GBAloft Aviation Services LLC · Spartanburg, SCBuilt 1960 · S/N BA-509 N325DSteggs Jeff E · Imperial, NEBuilt 1962 · S/N AF-695 N33JPScenic Flight Adventures LLC · Coeur D Alene, IDBuilt 1954 · S/N A-998 N33KMEckles Aircraft LLC · Weslaco, TXBuilt 1960 · S/N BA-534 N3500BWalter Charles T Jr · Ocala, FLBuilt 1953 · S/N A-973 N3532BPlane Crazy Aviation LLC · Hollywood, SCBuilt 1954 · S/N A-999 N360HS Dacy Enterprises Inc · Harvard, ILBuilt 1962 · S/N BA-621 N3647Dakota Territory Air Museum · Minot, NDBuilt 1952 · S/N CA-262 N3666GDream Weaver Aviation LLC · East Berlin, PABuilt 1951 · S/N 51-11771 N36BCBancroft Contracting Corp · South Paris, MEBuilt 1961 · S/N BA-571 N3710BEndless Mountain Skydivers Inc · Dalton, PABuilt 1955 · S/N BA-44 N3717SSetter Thomas · Burnsville, MNS/N BA-196 N372PSDb Aero Inc · Wilmington, DEBuilt 1964 · S/N BA-693 N375VUAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 51242 N380Dillon Flying Service Inc · Dillon, MTBuilt 1955 · S/N BA-42 N38BWRed Cloud Aviation LLC · Shawnee, OKBuilt 1965 · S/N BA-725 N38WSilverbird Vintage Aircraft & Flying Services LLC · Zeeland, MIBuilt 1960 · S/N BA-580 N390VKuehler Jon · Amarillo, TXS/N BA-419 N40074American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1954 · S/N AF 834 N400KUGudgel Daniel R · Lemoore, CABuilt 1961 · S/N BA-572 N40189Jacob Mark K · East Lansing, MIBuilt 1943 · S/N 51218 N404CKN404ck LLC · Anchorage, AKBuilt 1953 · S/N AF-297 N404HMid Atlantic Air Museum · Reading, PABuilt 1961 · S/N BA-590 N404TGreatest Generation Naval Museum · Colorado Springs, COBuilt 1959 · S/N BA-432 N408THKestrel/Hyline · West Des Moines, IABuilt 1955 · S/N BA-110

Back to AD 72-16-02 R3