AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-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:2002-07-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:2002-07-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:2002-07-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.
N325DDQuick Michael D · Middletown, CAN3279NTips Frederick J III · San Antonio, TXN327BWCessna N327bw LLC · Telluride, CON327CTYr-Aircraft Leasing LLC · Bethel, AKN32MCCook Tracy L · Prosper, TXN32PXKustatan Leasing LLC · Kenai, AKN32RLVb Glass Company Inc · Jamestown, CAN3309SCessna 210 N3309s LLC · Yellville, ARN3311SExperimental Aircraft Association Inc · Oshkosh, WIN3312SBas Part Sales LLC · Greeley, CON33189Schrage Rodney L · Steamboat Springs, CON33196One Niner Six Aviation LLC · Anchorage, AKN331CBN331cb LLC · Great Falls, MTN331LCEblc Aviation LLC · Hollywood, FLN33216Avarts LLC · New Castle, DEN33247R House Leasing LLC · Stormville, NYN33277Niebuhr Bradley A · Morriston, FLN3327SDavis Blake A · Bellevue, TXN3336SVancil Todd · Justin, TXN3337SBeery Bruce M · Lakeland, FLN333BCMcfadden John L · Cresson, TXN333DAFavor Michael D · Chico, CAN333FUIntricate Bay Operating LLC · Iliamna, AKN333GKCenturion210 LLC · Amherst, NHN333HRWilson Alan E Trustee · Erie, CON333JWPhillips John Patrick · Cumming, GAN333LB333lb LLC · Fort Worth, TXN333LHKoelbl Aviation LLC · Whitesboro, TXN333PSDoran Jeffrey T · Westerville, OHN3340SRegistration Pending · Wilmington, DERegistration pendingN3345SSummit Foundry Systems Inc · Fort Wayne, INN3347SArmitage Justin Marc · Hugoton, KSN334WCenturion Investments Inc DBA · Chesterfield, MON3350SBarry Jason J · Orange, CAN3351STarantino Nicholas T Jr · Union City, CAN3356SBbt Inc · Wilmington, DEN335SFRamont Ronald G Jr Trustee · Modesto, CAN3360SMohler Earl C · Bonita, CAN3363YCamlik Air LLC · Wausau, WIN3364SAir Deeken Ltd · Doylestown, OHN3365SWinger Cattle Co Inc · Johnson, KSN3366ST R Webster And Son Inc · Rexburg, IDN3368SForbes Amanda M · Huachuca City, AZN3369SC-210 Lc · Atlantic, IAN3372SBmf Services USA LLC · Satellite Beach, FLN3374SCcf Ventures Inc · Bangor, MEN337DMMcwhorter Michael S · Fortuna, CAN337PCPhantom Technologies LLC · Garden City, IDN3383SStewart Bryan · Carson City, NVN3388SShaffer Barbara J · Franklin, KY
Back to AD 2002-07-01