AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N3405SStutz Aaron M · Weed, CAN3405XMurray Lacounte O · Leander, TXN3405YCampbell Casey J · Sitka, AKN3405ZHeinrich Steven A · Corvallis, ORN34064Kupka John J · Okeechobee, FLN3406WQwikflights LLC · Herriman, UTN3406XThuerauf John E · Plum City, WIN3407CK&L Leasing And Investment LLC · Mountain Green, UTN3407FHoltzinger Tyler · Muscle Shoals, ALN3407LRoadarmel Brandon · Bozeman, MTN3407SWeaver Jason Andrew · Germantown, TNN3407UNote Clayton Rex · Eagle Point, ORN3407WYounkin Anthony · Ruffs Dale, PAN3407XAerodrome Aviation LLC · Brighton, CON3407ZBug Smashers LLC · Winfield, KSN3408RFronapfel Hannah A · Palmer, AKN3408TSpectron Aviation Inc · West Boylston, MAN3408XHeid Jason A · Crystal, MNN34097Brennan Benjamin M · Pensacola, FLN34099Nehrbass Daniel · Santa Ana, CAN3409MBelleau Clifford D · Anchorage, AKN3409NSchaffhauser Daniel · Garland, TXN3409RAnderson Curtiss B · Heber Springs, ARN3409YThies Trevor H · Seattle, WAN340ABBison Investment Advisors Inc · Lafayette, INN340ACMajor Travis S · Phoenix, AZN340ADN89vy LLC · Benson, NCN340AGRicker David · Conway, ARN340AHEden On Broad LLC · Cookeville, TNN340AJListo Aviation LLC · Chelsea, ALN340ALPellair LLC · Bellingham, WAN340ANO & M Industries Inc · Arcata, CAN340APVanel Clyde · Queens Village, NYN340ATArs Aviation LLC · Houston, TXN340AUAuburn University · Auburn, ALN340BNewberg Edgar T · Hector, MNN340BBJacobs Property Management LLC · Dutton, ALN340BCOutbound LLC · Sharonville, OHN340BDBd Flight Services LLC · Kearney, NEN340BEBurnett Enterprises Inc · Carpenter, WYN340BFRegistration Pending · Simi Valley, CARegistration pending, pending cancellationN340BGBowling Green Flight Center LLC · Bowling Green, OHN340BJGreat Western Aviation Leasing LLC · South Ogden, UTN340BKEldridge Aviation Inc · Lewes, DEN340BSCarey John P DBA · Marana, AZN340BWMcaden Dennis W · Wichita Falls, TXN340CDArgent Holding (USA) Ltd · Corona, CAN340CENeely Aviation Services Corp · Port Orange, FLN340CFOhara William P · Atco, NJN340CHAircraft & Aviation Professional LLC · Coldwater, MI
Back to AD 2007-04-19 R1