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.

N24RHBurns Texas Enterprises Inc · Houston, TXBuilt 1971 · S/N 18260817 N2500LRice Nancy Kay · Leesburg, TXBuilt 1966 · S/N 17255700 N2500QSaydun LLC · Richardson, TXBuilt 1967 · S/N 15066600 N2500RN2500r LLC · Florence, SCBuilt 1967 · S/N 18258200 N2501QEcological Flight Services LLC · Stuart, FLBuilt 1966 · S/N 18257701 N2502RLovell John W · Sherborn, MABuilt 1967 · S/N 18258202 N2502YSkinner Norman D · Osceola, IABuilt 1965 · S/N 17253227 N2503RNicoliei Paul · Ione, CAS/N 18258203 N2504LRogers Carol J · Hampshire, ILBuilt 1966 · S/N 17255704 N2504RJht Aviation LLC · Longview, TXBuilt 1967 · S/N 18258204 N2504XInspire Technologies Inc · Caldwell, IDBuilt 1964 · S/N P206-0004 N2505LCannon Jason P · La Verne, CABuilt 1966 · S/N 17255705 N2505XGaviaire Aviation LLC · El Reno, OKBuilt 1965 · S/N P206-0005 N2506QJohnson Jason D · Doniphan, MOBuilt 1966 · S/N 18257706 N2506XBaumberger Gene C · Greenville, ILBuilt 1965 · S/N P206-0006 N2507RKandle Sherry A · Boise, IDBuilt 1967 · S/N 18258207 N2508RBrodt Gregory L · Chetek, WIBuilt 1967 · S/N 18258208 N2508XCaspaar Valentin · Seattle, WABuilt 1965 · S/N P206-0008 N2509LSchufeldt Lawrence H · North Platte, NEBuilt 1966 · S/N 17255709 N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514 N2511LDmcflight LLC · Boynton Beach, FLS/N 17255711 N2511RDickey Mark D · Pendleton, ORS/N 18258211 N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712 N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2514LRegistration Pending · Macclenny, FLRegistration pendingS/N 17255714 N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2515LClear Air Aviation LLC · Talkeetna, AKBuilt 1966 · S/N 17255715 N2516LFlores E Alex · Missouri City, TXBuilt 1966 · S/N 17255716 N2516VGreat Adventure Sailing Vessell LLC · Greer, SCBuilt 1974 · S/N 177RG0601 N2517LCarroll Mark E · Nicholasville, KYBuilt 1966 · S/N 17255717 N2518QSwaldi Thomas · Marion Heights, PABuilt 1966 · S/N 18257718 N2519L2 G Group LLC · Honolulu, HIBuilt 1966 · S/N 17255719 N2519RPentzien Inc · Omaha, NEBuilt 1967 · S/N 18258219 N2520LPeck M Hayden II · Bells, TXBuilt 1966 · S/N 17255720 N2520QRcmt Properties LLC · Havre, MTBuilt 1966 · S/N 18257720 N2520RWinston Douglas S · Star, IDBuilt 1967 · S/N 18258220 N2521LExpert Construction Services LLC · Mclean, VAFirst renewal noticeBuilt 1966 · S/N 17255721 N2522QJohnson Sales & Service Inc · Ong, NEBuilt 1966 · S/N 18257722 N2522RPechanec Brent L · Wichita, KSBuilt 1967 · S/N 18258222 N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022 N2523QLusk T Quizy · Springfield, COBuilt 1966 · S/N 18257723 N2523RBergamaschi Brian A Trustee · Davis, CABuilt 1967 · S/N 18258223 N2524LGraham Jacob W · Rose Hill, KSBuilt 1966 · S/N 17255724 N2524QBellamy Flying LLC · Elwood, NEBuilt 1966 · S/N 18257724 N2525QHohman Cory A · Lometa, TXBuilt 1966 · S/N 18257725 N2525RBrandt Jimmie L · Elbert, COBuilt 1967 · S/N 18258225 N2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKBuilt 1967 · S/N 18258226 N2526XBolin David A · Kenmore, WAS/N P206-0026

Back to AD 72-03-03 R3