Skip to content

Registered aircraft · 40,395

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

N38629Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1977 · S/N 28-7790573 N3862KNeihart Randy L · Fontana, CABuilt 1967 · S/N 28-23753 N3862MN3862m LLC · Provo, UTS/N 28-7890337 N3862QQ Flyers LLC · Anaheim, CABuilt 1971 · S/N 17259962 N3862ZAdams Bob L · Eagle River, AKBuilt 1961 · S/N 18-7637 N3863QCondor Air LLC · Pleasant Valley, NYBuilt 1971 · S/N 17259963 N3864MAscent Aviation LLC · Van Nuys, CABuilt 1978 · S/N 28-7890338 N3864NScherffius Steven H · Louisville, KYBuilt 1981 · S/N M-2311 N3864QEvans James · Tuolumne, CAS/N 17259964 N3864ZHorizon Transportation And Rentals LLC · Phoenix, AZBuilt 1961 · S/N 18-7641 N38656Allen James R · Olympia, WABuilt 1977 · S/N 28-7716272 N38657W I F A (Washington International Flight Acad) LLC · Gaithersburg, MDBuilt 1977 · S/N 28-7790574 N3865QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259965 N3866PWateractive43 LLC · Auburn, CABuilt 1955 · S/N 22-3558 N3866QOcala Aviation Services Inc · Ocala, FLBuilt 1971 · S/N 17259966 N3866RDurgin William W · Waquoit, MABuilt 1970 · S/N 28-5845 N3866ZForestry Aero LLC · Norwood, LABuilt 1961 · S/N 18-7647 N3867QLangner Dale R · Louisburg, KSBuilt 1971 · S/N 17259967 N3867ZGaller Frank G · Elysian, MNBuilt 1961 · S/N 18-7648 N3868RGentry Donald R · Welaka, FLBuilt 1969 · S/N 28-5770 N38692Markis Dean · Lake Worth, FLBuilt 1977 · S/N 28-7725263 N38694Chapman Daniel H · Yucaipa, CABuilt 1977 · S/N 28-7790576 N38696Lake Area Technical College · Watertown, SDBuilt 1977 · S/N 28-7790577 N3869QNew Garden Township · Landenberg, PABuilt 1971 · S/N 17259969 N386BNebbia Valter Della · Archer City, TXBuilt 1957 · S/N TD-4 N3870MSloan William R · Anchorage, AKBuilt 1947 · S/N 12-2789 N3870PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 22-3563 N3870QLake Waccamaw Aviation LLC · Lake Waccamaw, NCBuilt 1971 · S/N 17259970 N3871MProut Paul D · Eveleth, MNBuilt 1947 · S/N 12-2886 N3871RFly Vermont LLC · Swanton, VTBuilt 1970 · S/N 28-5846 N3871XJohnson Roger L · Broken Arrow, OKBuilt 1967 · S/N 168 N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972 N3872XBehrens Bros Aviation LLC · Gerald, MOBuilt 1967 · S/N 170 N3872ZHale Mitchell D · Chugiak, AKBuilt 1961 · S/N 18-7657 N38733Lauren Erick · Hollister, CABuilt 1977 · S/N 28-7790580 N38735Schulz Lewis E III · Sand Springs, OKBuilt 1977 · S/N 28-7790581 N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973 N3873ZSchok Richard N Jr · Fairbanks, AKBuilt 1961 · S/N 18-7661 N3874PPearson Joshua J · Unionville, MOS/N 22-3567 N3874XTr Flying Service LLC · Milan, MNBuilt 1967 · S/N 173 N3874ZSlinkard Justin W · Bakersfield, CABuilt 1961 · S/N 18-7734 N3875PLonnevik Dennis F · Bigfork, MTBuilt 1955 · S/N 18-4701 N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975 N3875XTate Maurice J · Hope Valley, RIS/N 174 N3876PBreen George R · East Falmouth, MABuilt 1956 · S/N 18-4702 N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976 N3876XFlying Weenie LLC · Henderson, TXBuilt 1967 · S/N 175 N38777Medsker Doug S · Graham, MOBuilt 1977 · S/N 28-7816181 N3877PBranson Derrick · Seward, AKBuilt 1955 · S/N 18-4703 N3877ZAlsworth John H · Anchorage, AKBuilt 1961 · S/N 18-7668

Back to AD 79-10-03 R2