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.
N4331DAlvarado John · Brownsville, TXN4331ECmb Holdings LLC · Logansport, INN4331MNieves Osvaldo Colon · San Juan, PRN4331PWilson Cecil · Lithonia, GAN4331QLewis Brandon · Columbiaville, MIN4331RConsolidated Aviation Services LLC · Seymour, TNN4331WRicca Gregory F Trustee · Bentonville, ARN4331XS E D Air LLC · Kimball, SDN4331YOdonnell Daniel V · Dover, DEN43321Alexander Terry · Stamps, ARFirst renewal noticeN43325Air Ventures Flying School LLC · Smithfield, RIN43326Draco Flight School DBA · Chino, CAN4332AButterfield Robert S · Shelbyville, INN4332COdom Douglas · Jay, FLN4332GEdmundson George · Hood River, ORN4332LRubman Tracy L · Shelburne, VTN4332NThree Wing Flight School LLC · Stratford, CTN4332RHolland Peter B · Uniontown, WAN4332XRotor Spec Aviation LLC · Star, IDN4332ZSipes Harold T · North Pole, AKN43335Coleman James M · Aiken, SCN43337Monadnock Aviation Inc · Keene, NHN4333AAir-Mods Flight Academy Inc · Robbinsville, NJN4333BLand & Leave LLC · Helena, MTN4333CSmart 02 LLC · Kissimmee, FLN4333JHaengel Marci M · Canton, MIN4333KWeisbeck Kenneth J · Scottsdale, AZN4333PTinny Twister Aviation LLC · Fort Myers, FLN4333RReigle Aviation · Palmyra, PAN4333TBluebird Airventures LLC · Bosque Farms, NMN4333XKoglmeier Matthew D · Mesa, AZN4333YEvergreen Soaring Inc · Lynnwood, WAN43348A Bit Extra LLC · River Ridge, LAN4334BRed Five Air LLC · Stuart, FLN4334JBest Equipment Leasing LLC · Bakersfield, CAN4334LOcuto Vincent Louis II · Homestead, FLN4334PWelke Aviation Inc · St James, MIN4334QDickey Alan J · Fort Wayne, INN4334RAir Dakota Flite Inc · Hettinger, NDN4334V305 Aviation Group Inc · Miami, FLN4334XOxford Flying Club Inc · Oxford, CTN43352Lucas Jonah R · Beattyville, KYN43353Venture North Aviation LLC · Cloquet, MNN43355Calloway Enterprises LLC · Johnson City, TNN4335DSparrowhawk Aviation LLC · Hollister, CAN4335HRiisnaes Alf Kare E · Rapid City, SDN4335JByas Victor Jr · Cleveland, MSN4335KDodge Colleen Marie · Lake Geneva, WIN4335MCondor Aero Club Inc · Zelienople, PAN4335YTexas Soaring Association Inc · Midlothian, TX
Back to AD 2007-04-19 R1