AD 79-10-14 R1
Registered aircraft · 56,582
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
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-14-R1')
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-14-R1')
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-14-R1') 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-14-R1') 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.
N736BJSmith Ryan James · West Barnstable, MAN736BMFoster Steven C · Soldotna, AKN736BVHaver Harold M · Colorado Springs, CON736BWDirect To Aviation LLC · Pueblo, CON736BYGmm Records · Big Pine Key, FLN736CAT & C Transportation LLC · Dandridge, TNN736CBWilley Ronald S · Sebago, MEN736CJAndrews Brian S · Venus, TXN736CKOk Tire Factory Inc · Okanogan, WAN736CNThomas Jamie A · Summersville, WVN736CQHicks Shannon M · Lake Havasu City, AZN736CSMenard Denis J · Louisville, KYN736CYWoldorf Jordan L · Birdsboro, PAN736CZStamper Tom J · Archdale, NCN736DBAerial Crop Services LLC · East Prairie, MON736DDLaforge John W · Midland, TXN736DEJasinski Anthony S · Bluemont, VAN736DHAviation Management LLC · Missoula, MTN736DJFly Guy LLC · Murphy, TXN736DKNelson Thomas H Jr · Chatham, MSN736DMCasillas Carlos Eduardo · El Paso, TXN736DNCousin William C · Hugo, OKN736DUJm Bryson Inc · Granada Hills, CAN736DVBradford William O Jr · Huntersville, NCN736EBTesta Sam C · Bonners Ferry, IDN736ECBailey Mark H · Bluffton, SCN736EDSelwyn Rebekah L Trustee · Eastsound, WAN736EFWalding Grant L · Coos Bay, ORN736EGMoore Samuel R Jr · Tabernacle, NJN736EHGarvin Lee E · Brookings, ORN736EJDodson International Parts Inc · Rantoul, KSN736EMPerez Carlos E · Bayshore, NYN736EQHarper Henry A · Mesquite, NVN736ESRainbow Aviation Services · Kingsville, MON736ETSchuler Darrell II · Bridgeport, NEN736EUSolano Aircraft Maintenance LLC · Torrance, CAN736EVRogerson James H · Chandler, AZN736EXHolt Aviation LLC · Clear Lake, IAN736FADebold Denise S · Spring, TXN736FBNimbus 2000 LLC · Farmington, UTN736FCJrm Wings LLC · Farmington, UTN736FDKing Brad C · Langley, WAN736FFNorkunas Lisa M · Fontana, CAN736FGJ M Carrigan LLC · Sanibel, FLN736FJHartwick Kevin D · Crescent City, CAN736FNWilliamson Thomas M · Southport, NCN736FSRussell Larry B DBA · Union City, TNN736FTChoice Aviator LLC · Chandler, AZN736FVDel Rio Advisors LLC · Modesto, CAN736FXKelcy Wyman O · Early, TX
Back to AD 79-10-14 R1