AD 2002-11-07
Registered aircraft · 1,512
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-11-07')
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-11-07')
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-11-07') 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-11-07') 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.
N2150LB-58 Inc · Albany, GAN215CHKld Air LLC · Charlotte, NCN219CHSteel Eagle Aviation LLC · Birmingham, ALN219GMStewart Michael A · Washington, DCN21DAW Squared Holdings LLC · Edmond, OKN21JPDmmag LLC · Windermere, FLN21LPLp Aviation Inc · Wilmington, DEN21MFOsgood Air LLC · Hays, KSN21NPRossi Michael · Ronan, MTN21YMCape Fear Transport Inc · Elizabethtown, NCN2205LAerocare LLC · Oak Ridge, TNN221CHBas Part Sales LLC · Greeley, CON2224DHanger South Aviation LLC · Paragould, ARN222GSLandau Management Services Inc · Topanga, CAN222PGShokoohi Mehdi · Anaheim Hills, CAN222RBwr Aircraft LLC · Paramus, NJN222RBM & B Llp · Iowa City, IAN222RGVaerus Jet Sales LLC · Topeka, KSN222RZP & M Reis Trucking Inc · Nantucket, MAN22334Fredericks Hall Aviation LLC · Mineral, VAN223KMWithrotor Aviation Inc · Lakeview, ORN223SBAdams Derek · Lexington, MAN225TAN225ta LLC · Loganville, GAN2264LWoolum Stephanie · Varney, WVN2271LBurchinal Skyler · Brookston, TXN227BRSchoo Michael J Trustee · Ridgway, CON2280BDream Flight Aviation LLC · New Fairfield, CTN2288LCherryhill Aviation Inc · Freetown, INN2289ERegistered aircraftN22917Paducah Midstream Grocery Inc · Paducah, KYN229TARemes Stephen · Northfield, MNN22CCLegacy Air LLC · Oklahoma City, OKN22TYCygnus9 LLC · Fayetteville, NCN22VXDo Good Things LLC · Port Orange, FLN231LCFirst United Inc · Seminole, FLN231WEJones Jason Bart · Frankfort, ILN2333BN2333b LLC · Oklahoma City, OKN2335RPropellerhead Aviation LLC · Santa Cruz, CAN233CTHoneycutt Danny · Angier, NCN2347GSmith Steven L · Whitehall, MTN2348QLegha Jaskirat · Holly Ridge, NCN234MGDubin Wayne M Trustee · Fort Myers, FLN2352YMilton Jerry D · Lillington, NCN23571Dlat Holdings LLC · Allen, TXN23589High Times Adventure Co LLC · Columbiana, ALN2358KSmith Aeromotive Charters Inc · Excelsior, MNN235DRegistration Pending · Mead, CORegistration pendingN235SMTriniair LLC · Warner Robins, GAN237DCHinkle Airspray Inc · Cavalier, NDN23KMR H Phillips Trucking Co Inc · Shelby, OH
Back to AD 2002-11-07