AD 72-02-01
Registered aircraft · 282
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:72-02-01')
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-02-01')
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-02-01') 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-02-01') 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.
N234DADestination Management LLC · Tulsa, OKN238FALetourmeau University · Longview, TXN239SERiley Charles Sweeney · Highlands Ranch, CON23DTAlastrom Aviation LLC · Wilmington, DEN240RTAviation Trust Company LLC Trustee · Oklahoma City, OKN241TSGrey Matter Inc · Valley Springs, CAN242HB2hb Airways LLC · Saint Louis, MON251WWEbbert Thomas E DBA · Gary, INRegistration revokedN25FERound Trip Lc · Elkhart, KSN269FAir2615 LLC · Wilmington, DEN2836DSale Reported · Yucaipa, CASale reportedN285NTotem Air Inc · Seattle, WAN28835Waddingham William B · Rancho Cucamonga, CAN2957QGenerals International Inc · Red Oak, TXN2979SAerospace Trust Management LLC Trustee · Wilmington, DEN300MBIglesia De Cristo · Porter Ranch, CAN304MCValiair Lc Trustee · Casper, WYN315MDuckwing LLC · Reno, NVN318PPK&A Consulting Of Montana Inc · Billings, MTN318TWFlg Air Transport LLC · Miramar, FLN31KCWashington State Community College · Spokane, WAN31KSPaxton Jacob · Killeen, TXN31KTSmith Kenneth L · Pomona, CAN321HASkytook LLC · Wilmington, DEN333CJDrj Aviation LLC · Dover, DEN333KWD G R Air LLC · Braselton, GAN333SFFerretti James L III · Port Orange, FLN3377QMendez Jr Leo · Corpus Christi, TXN3398QRiebe Grover C Jr · Gwinner, NDN3540MDybel William P · Frankfort, ILN355RTBeechwood Aviation LLC · Wilmington, DEN35FSSelistli LLC · San Mateo, CAN37676Campbell & Associates Investment Properties LLC · Burleson, TXN37JKSsr LLC · Incline Village, NVN37MBresciani Martin · Guaynabo, PRN382MCShiver James B · Stanley, NMN384AMHaggard Haley G · Springer, OKN400BJAirrich LLC · Largo, FLN400CEMcmurray Bradley Thomas · Advance, NCN400TMPaxton Homes LLC · Killeen, TXN4070LDesert Air LLC · Hagerman, NMN4074LEminent Technology · Tallahassee, FLN40JCDbs Aviation LLC · Sulphur Springs, TXN41019Sjs Flights Lp · Columbus, GAN41041Mathews Christopher D · Blue Earth, MNN41055J&B Aircraft LLC · Anaheim, CAN41085421 Bravo LLC · Marine City, MIN410ECSoutheast Enterprises LLC · Dothan, ALN41106Delorenz Robert J · Boca Raton, FLN41114Iacobacci Timothy R · Fairborn, OH
Back to AD 72-02-01