Skip to content

Registered aircraft · 17,027

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-03-03-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-03-03-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-03-03-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-03-03-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-03-03-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-03-03-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.

N6349SMazzarese Nicholas · Cedar Hills, UTS/N 15067149 N634AHyatt Alex K · Locust Grove, GABuilt 1960 · S/N 634 N634EHEd-Air Inc · Oaktown, INBuilt 1971 · S/N A1500315 N634WGWings Of Grace Ministries Inc · Melbourne, FLFirst renewal noticeBuilt 1965 · S/N 17252781 N6350GZimny Daniel M · Rancho Cordova, CAS/N 15071850 N6351GWhirling Wings LLC · Lexington, NCBuilt 1970 · S/N 15071851 N6352GJohnson Jeffrey L · Paradise, CABuilt 1970 · S/N 15071852 N6355SLudmerer Victor J · Greenwood Lake, NYBuilt 1967 · S/N 15067155 N6356GBettega Gerald E · Lutz, FLBuilt 1970 · S/N 15071856 N6356STurner Dale W · Moore Haven, FLBuilt 1967 · S/N 15067156 N635MSpl Invest LLC · Chandler, AZBuilt 1964 · S/N 17252253 N6361GHalley Dan R · Avery, TXBuilt 1970 · S/N 15071861 N6361SSchade Scott · Green Valley, AZBuilt 1967 · S/N 15067161 N6362SMott Charles A Jr · Chesapeake, VABuilt 1967 · S/N 15067162 N6363GGillis Timothy L · Kenai, AKBuilt 1970 · S/N 15071863 N6363SSnell Matthew L · Ackerly, TXS/N 15067163 N6364GCarlstadt William A · South Bound Brook, NJBuilt 1970 · S/N 15071864 N6365GN6365g LLC · Buckeye, AZBuilt 1970 · S/N 15071865 N6366GTownson Charlotte K · Cisco, TXBuilt 1970 · S/N 15071866 N6367SLogtime Flight LLC · Lancaster, TXBuilt 1967 · S/N 15067167 N6368SMommsen Robert V · Ketchikan, AKS/N 15067168 N636WCMcgivern Mark M · Fountain Hills, AZBuilt 1962 · S/N 18253965 N6374GLilbit Industries LLC · Oklahoma City, OKBuilt 1970 · S/N 15071874 N6377SVillalba Raymond · Spring, TXBuilt 1967 · S/N 15067177 N6378GHigh Exposure Inc · Wilmington, DEBuilt 1970 · S/N 15071878 N6379SMcdonald Gregory S · Mena, ARBuilt 1967 · S/N 15067179 N6383HWest Brian L · Creston, IABuilt 1973 · S/N 15074956 N6383SNightingale Matthew · Rancho Cucamonga, CABuilt 1967 · S/N 15067183 N6384SSalter William Jeffrey · New Smyrna Beach, FLS/N 15067184 N6385SPalmer Dana G · Gatesville, TXS/N 15067185 N6386GSonafrank Eric · Somerset, INBuilt 1970 · S/N 15071886 N6388GGaller Frank G · Elysian, MNBuilt 1970 · S/N 15071888 N6389GHagen Alfred · Bensalem, PABuilt 1970 · S/N 15071889 N6390SStraub Aircraft Holdings LLC · Overland Park, KSBuilt 1967 · S/N 15067190 N6394SLincoln Air LLC · Kalispell, MTBuilt 1968 · S/N 182-59002 N6398DAdx Holdings Lp · Marble Falls, TXS/N 18256755 N6398GCrowned Eagle Aviation LLC · South Saint Paul, MNBuilt 1970 · S/N 150-71898 N63GOneil Liam Trustee · Vashon, WABuilt 1972 · S/N 17260616 N63VTFlyways LLC · Bemidji, MNBuilt 1969 · S/N 18259760 N63WSCooks Saw Manufacturing LLC · Newton, ALBuilt 1964 · S/N 21058333 N6400FAirplanes Unlimited LLC · Jackson, TNBuilt 1966 · S/N 15063000 N6400GCollier James S · Jesup, GABuilt 1970 · S/N 15071900 N6401FPfd Aviation LLC · Sheridan, WYBuilt 1966 · S/N 15063001 N6402FMaier Andrew J · Barnesville, MNBuilt 1965 · S/N 15063002 N6403FFertile Flying Club Inc · Fertile, MNBuilt 1966 · S/N 15063003 N6403GKassel Willard C · Sicily Island, LAS/N 15071903 N6404GWarrior Aviation LLC · Prior Lake, MNBuilt 1970 · S/N 15071904 N6405GArmond Richard J · Thousand Oaks, CABuilt 1970 · S/N 15071905 N6409FStatusair LLC · Mount Arlington, NJBuilt 1966 · S/N 15063009 N6409XValdes Omar F · Huntington Park, CAS/N 15068652

Back to AD 72-03-03 R3