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.

N19600Corona Police Aero Squadron Inc · Calimesa, CABuilt 1972 · S/N 17260600 N19601Pnl Aviation LLC · Brunswick, MEBuilt 1972 · S/N 17260601 N19602Lucas Mitchell H · Jackson, GABuilt 1972 · S/N 17260602 N19603Stanly Business Consultants LLC · Albemarle, NCBuilt 1972 · S/N 17260603 N19606Stettner George J · Spring Hill, FLBuilt 1972 · S/N 17260605 N19609Johnson Erik S · Navarre, FLBuilt 1972 · S/N 17260607 N1960XPena Fermina · Brentwood, NYBuilt 1964 · S/N 18256060 N19610Berg John R · San Pedro, CABuilt 1972 · S/N 17260608 N19614Clark David R · Terrebonne, ORBuilt 1972 · S/N 17260611 N19618Seymour David E · Evergreen, COBuilt 1972 · S/N 17260614 N19620Schmidt Jeffrey A · Othello, WAFirst renewal noticeBuilt 1972 · S/N 17260615 N19622Baker Timothy G · Curtis, NEBuilt 1972 · S/N 17260617 N19624Jlinn Aviation Inc · Quinlan, TXBuilt 1972 · S/N 17260618 N19625Novak Daniel F · Palmyra, WIBuilt 1972 · S/N 17260619 N19629Anvab Inc DBA · Concord, NHBuilt 1972 · S/N 17260623 N19630Brignoni Ruben Mercado · Isabela, PRBuilt 1972 · S/N 17260624 N1963QJohnson Clinton B · Alpharetta, GABuilt 1973 · S/N 177RG0363 N19640George Gary D · Humble, TXBuilt 1972 · S/N 17260629 N19643Kuester Ryan J · West Point, NEBuilt 1972 · S/N 17260631 N19644Hyde Shawn M · Columbus, OHS/N 17260632 N19646All2fly LLC · Atlanta, GABuilt 1972 · S/N 17260634 N19648Registration Pending · Cumming, GARegistration pendingBuilt 1972 · S/N 17260635 N1964QAction Air LLC · Missoula, MTBuilt 1973 · S/N 177RG0364 N19650Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260637 N19655Kincaid William R · Niceville, FLS/N 17260640 N19657Thomas Mark E · Corpus Christi, TXBuilt 1972 · S/N 17260642 N19658Gavel Robert E Jr · Keaau, HIBuilt 1972 · S/N 17260643 N19665H&L Axelsson Inc · Cape May, NJS/N 17702582 N19667Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1972 · S/N 17260650 N19668Yent Kevin N · Tampa, FLBuilt 1972 · S/N 17260651 N19669Sprague John F · Chico, CABuilt 1972 · S/N 17260652 N19671Cascade Aviation LLC · Burlington, WABuilt 1972 · S/N 17260654 N19673Transair Inc · Blue Ridge, GAS/N 17260656 N19674Mcgraw Amiyah S · Jurupa Valley, CABuilt 1972 · S/N 17260657 N19676Whitman David L Jr · Centreville, VABuilt 1972 · S/N 17260659 N19679N19679 LLC · Opa Locka, FLS/N 17260662 N1967SFullerton Airport Pilot Association · Fullerton, CABuilt 1972 · S/N 17260661 N1967USmith Bernard A · Wasilla, AKBuilt 1968 · S/N 17257827 N1967XInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 18256067 N19680Proflight Services LLC · West Newton, PABuilt 1972 · S/N 17260663 N19681J & J Shop Heliair LLC · Laurel, DES/N 17260664 N19682Steward James Mark · Colorado Springs, COBuilt 1972 · S/N 17260665 N19684Belt Jay D · Bluefield, WVBuilt 1972 · S/N 17260667 N19687Dg Aviation LLC · Mechanicville, NYBuilt 1972 · S/N 17260670 N19688Vista Air Inc · Pacoima, CABuilt 1972 · S/N 17260671 N19692Babyshark LLC · Duncan, OKS/N 17260675 N19695Saint Aviation Inc · Dunnellon, FLBuilt 1972 · S/N 17260677 N19698Northern Air Aviation LLC · Naples, IDBuilt 1972 · S/N 17260680 N1969KRegistered aircraftBuilt 1968 · S/N 17257813 N1969QKalis Jeffrey J · Sparta, MIBuilt 1973 · S/N 177RG0369

Back to AD 72-03-03 R3