AD 2001-02-13
Registered aircraft · 671
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:2001-02-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-02-13')
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:2001-02-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-02-13') 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.
N525JLMadison Air LLC · Big Sky, MTN525JMJ D Leasing LLC · Wilmington, DEN525JVJ P Ferguson Aviation LLC · Oxford, MSN525JWWashington Road Properties Level 2 LLC · Highlands, NCN525KAPhysical Systems Inc · Carson City, NVN525KBLast Bird LLC · Santa Fe, NMN525KHKh Aviation Tbm 850 LLC · Prospect Heights, ILN525KMYy LLC · Kalispell, MTN525KSNt Aviation LLC · Wichita, KSN525LAArkten Jet Partners LLC · Jonesboro, ARN525LEJet Options LLC · Indianapolis, INN525LKKovacs Louis Attila Trustee · Saratoga, CAN525LMCth Rentals LLC · Halls, TNN525LPTeam Financial Inc · Birmingham, ALN525LWN525lw Corp Trustee · Wilmington, DEN525LXV2 Aviation LLC · Chattanooga, TNN525MBPortobello LLC · Fort Payne, ALN525MHFoster Time LLC · Midland, TXN525MMRst Ventures LLC · Franklin, MIN525MSBuilding Specialties Co Of Western Pennsylvania · Saxonburg, PAN525MWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN525MXAmdel Holding LLC · Houston, TXN525NCF & F Aviation LLC · Memphis, TNN525NVBeers Investment Group Toys LLC · Saint Petersburg, FLN525PGEvo Leasing LLC · Chandler, AZN525PJAdirondack Jets LLC · Scottsdale, AZN525PLRegistered aircraftN525PTR&D Aviation LLC · Florence, ALN525RAJackson Aviation LLC · Dayton, ORN525RCCerovest Capital LLC · Lawrenceville, GAN525RKWest Chester Permit LLC · Cincinnati, OHN525RMBenham James M · College Station, TXN525RPBravo Foxtrot Aviation LLC · Tucker, GAN525RYRegistered aircraftN525SYQualitair LLC Trustee · MichelstadtN525TFSl Jet Cj LLC · Cleveland, TNN525TGRoyal Air LLC · Glenwood Springs, CON525UHTextron Aviation Inc · Wichita, KSN525USRegistered aircraftN525VDelair LLC · Arden, NCN525WBContec Inc · Spartanburg, SCN525WCOption Air LLC · Lawrence, MAN525WEMv Flight Services LLC · Weslaco, TXN525WFKentucky Aviation Solutions LLC · Frankfort, KYN525WRCas Aircraft LLC · Bossier City, LAN525WWN525ww LLC · Millsboro, DEN525WXXsurgo Aviation Inc · Nashville, TNN525XDOuter Reef LLC · Bend, ORN525XPFull Send Aviation LLC · Wilmington, NCN526ABAmandair LLC · Concord, MA
Back to AD 2001-02-13