AD 2002-01-23
Registered aircraft · 329
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-01-23')
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-01-23')
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-01-23') 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-01-23') 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.
N675UPWheels Up Partners LLC · New York, NYN676UPCove Capital Investments LLC · Wilmington, DEN677KEJgp Aviation LLC · St Joseph, MON679SJDodson International Parts Inc · Rantoul, KSN686SCKa Corp · Missoula, MTN68GSFriesen Group Inc · Redding, CAN706RMUt Air LLC · Miami, FLN709ELRcm Air LLC · Davie, FLN710RAA & E Hawker Lp · Santa Ana, CAN719ELEdra Lauren Leasing Corp · Cincinnati, OHN71TAPlane Holdings LLC · Shawnee, KSN720XPLegacy Capital Transportation LLC · Knoxville, TNN726PGWheless Interests LLC · Shreveport, LAN727KBKenmore Crew Leasing Inc Trustee · Bellingham, WAN732WBCentral Iowa Aviation LLC · Ankeny, IAN75RLMhi Aviation LLC · Saint Rose, LAN75TGSkylink Resources LLC · Tulsa, OKN765KCJetset LLC · Denison, TXN774CC4 C Aviation LLC · Liberal, KSN777FEUnlimited Boat Sales Inc · Page, AZN777GBw Aero LLC · Pleasant Valley, MON793TBRedtail LLC · Oklahoma City, OKN799SJAircraft Trustee Services Inc Owner Trustee · Dover, DEN79EKMcorp Air LLC · Fort Lauderdale, FLN79ELEdra Lauren Leasing Corp · Cincinnati, OHN79VBDsw LLC · Wilmington, DEN800SDAircraft Charter Group LLC · Opa Locka, FLN80APAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN818CRBank Of Utah Trustee · Salt Lake City, UTN819FGFriesen Group Inc · Redding, CAN81QDQuality Dining Inc · Mishawaka, INN824HGLiftreat Services LLC · Lewes, DEN829HMJersey Aviation LLC · Stamford, CTN829KKJck Real Estate LLC · White Deer, TXN82QDEncore Jet Management LLC · San Antonio, TXN831KBAe Leasing LLC · Topeka, KSN843RHRgh Texas Air LLC · Pampa, TXN855RAA2 Aviation LLC · Gulfport, MSN864WVD-Kal Leasing LLC · Meadowbrook, WVN872RAA&E Hawker Lp · Santa Ana, CAN877JM And D Aviation LLC · Tulsa, OKN880MGDream Jet LLC · Leawood, KSN88UACentral Virginia Aviation Inc · Petersburg, VAN895CPPag Inc · Little Rock, ARN8ECEly Aviation LLC · Cartersville, GAN8YMBeechjet Aviation Inc · Marietta, GAN902RYJkpst Fly LLC · Davenport, IAN907JEDestiny Venture LLC · Brownsville, TXN907MXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN90CUMc Aviation LLC · Hawkins, TX
Back to AD 2002-01-23